In [2]:

import pandas as pd
import numpy as np
import scipy.stats as stats
from scipy.stats import zscore
import matplotlib.pyplot as plt
from soccerplots.radar_chart import Radar
from mplsoccer import PyPizza, add_image, FontManager
import math
from PIL import Image
import imageio

In [307]:

#Read in CSV file

df = pd.read_csv('FbrefSB2122.csv')
pd.set_option('display.max_rows', 500)
pd.set_option('display.max_columns', 500)

In [308]:

df.head()

Out[308]:

	Player	Nation	Pos	Squad	Comp	Age	Born	MP	Starts	Min	npGoals	npxG+xA	Goals	Shots	SoT	SoT%	Sh/90	SoT/90	G/Sh	G/SoT	AvgShotDistance	FKShots	xG	npxG	npxG/Sh	G-xG	npG-xG	PassesCompleted	PassesAttempted	TotCmp%	TotalPassDist	ProgPassDist	ShortPassCmp	ShortPassAtt	ShortPassCmp%	MedPassCmp	MedPassAtt	MedPassCmp%	LongPassCmp	LongPassAtt	LongPassCmp%	Assists	xA	A-xA	KeyPasses	Final1/3Cmp	PenAreaCmp	CrsPenAreaCmp	ProgPasses	LivePass	DeadPass	FKPasses	ThruBalls	PassUnderPress	Switches	Crs	CK	InSwingCK	Ground	Low	High	Left	Right	Head	ThrowIn	Other	PassesToOff	PassesOOB	PassesInt	PassesBlocked	SCA	SCA90	SCAPassLive	SCAPassDead	SCADrib	SCASh	SCAFld	SCADef	GCA	GCA90	GCAPassLive	GCADrib	GCASh	GCAFld	GCADef	DrbTkl	TklWinPoss	Def3rdPress	Mid3rdPress	Att3rdPress	DrbTkl.1	DrpPastAtt	DrbTkl%	DrbPast	Press	PressSucc	PressSucc%	Def3rdPress.1	Mid3rdPress.1	Att3rdPress.1	Blocks	ShBlocks	ShSvBlocks	PassBlocks	Int	Tkl+Int	Clr	Err	Touches	DefPenTouch	Def3rdTouch	Mid3rdTouch	Att3rdTouch	AttPenTouch	LiveTouch	SuccDrb	AttDrb	DrbSucc%	PlDrbPast	Megs	Carries	TotCarryDist	PrgCarryDist	ProgCarries	CarriesToFinal3rd	CarriesToPenArea	CarryMistakes	Disposesed	PassTarget	ReceivedPass	Receive%	ProgPassesRec	Yellows	Reds	Fls	Fld	Off	PKwon	Recov	AerialWins	AerialLoss	AerialWin%	npGoalsPer90	npxG+xAPer90	GoalsPer90	ShotsPer90	SoTPer90	SoT%Per90	Sh/90Per90	SoT/90Per90	G/ShPer90	G/SoTPer90	AvgShotDistancePer90	FKShotsPer90	xGPer90	npxGPer90	npxG/ShPer90	G-xGPer90	npG-xGPer90	PassesCompletedPer90	PassesAttemptedPer90	TotCmp%Per90	TotalPassDistPer90	ProgPassDistPer90	ShortPassCmpPer90	ShortPassAttPer90	ShortPassCmp%Per90	MedPassCmpPer90	MedPassAttPer90	MedPassCmp%Per90	LongPassCmpPer90	LongPassAttPer90	LongPassCmp%Per90	AssistsPer90	xAPer90	A-xAPer90	KeyPassesPer90	Final1/3CmpPer90	PenAreaCmpPer90	CrsPenAreaCmpPer90	ProgPassesPer90	LivePassPer90	DeadPassPer90	FKPassesPer90	ThruBallsPer90	PassUnderPressPer90	SwitchesPer90	CrsPer90	CKPer90	InSwingCKPer90	GroundPer90	LowPer90	HighPer90	LeftPer90	RightPer90	HeadPer90	ThrowInPer90	OtherPer90	PassesToOffPer90	PassesOOBPer90	PassesIntPer90	PassesBlockedPer90	SCAPer90	SCA90Per90	GCAPassLivePer90	GCAPassDeadPer90	GCADribPer90	GCAShPer90	GCAFldPer90	GCADefPer90	GCAPer90	GCA90Per90	GCAPassLive.1Per90	GCADrib.1Per90	GCASh.1Per90	GCAFld.1Per90	GCADef.1Per90	DrbTklPer90	TklWinPossPer90	Def3rdPressPer90	Mid3rdPressPer90	Att3rdPressPer90	DrbTkl.1Per90	DrpPastAttPer90	DrbTkl%Per90	DrbPastPer90	PressPer90	PressSuccPer90	PressSucc%Per90	Def3rdPress.1Per90	Mid3rdPress.1Per90	Att3rdPress.1Per90	BlocksPer90	ShBlocksPer90	ShSvBlocksPer90	PassBlocksPer90	IntPer90	Tkl+IntPer90	ClrPer90	ErrPer90	TouchesPer90	DefPenTouchPer90	Def3rdTouchPer90	Mid3rdTouchPer90	Att3rdTouchPer90	AttPenTouchPer90	LiveTouchPer90	SuccDrbPer90	AttDrbPer90	DrbSucc%Per90	PlDrbPastPer90	MegsPer90	CarriesPer90	TotCarryDistPer90	PrgCarryDistPer90	ProgCarriesPer90	CarriesToFinal3rdPer90	CarriesToPenAreaPer90	CarryMistakesPer90	DisposesedPer90	PassTargetPer90	ReceivedPassPer90	Receive%Per90	ProgPassesRecPer90	YellowsPer90	RedsPer90	FlsPer90	FldPer90	OffPer90	PKwonPer90	RecovPer90	AerialWinsPer90	AerialLossPer90	AerialWin%Per90	90sPer90	AvgTeamPoss	OppTouches	TeamMins	TeamTouches90	pAdjTkl+IntPer90	pAdjPressSuccPer90	pAdjClrPer90	pAdjShBlocksPer90	pAdjIntPer90	pAdjDrbTklPer90	pAdjTklWinPossPer90	pAdjDrbPastPer90	pAdjAerialWinsPer90	pAdjAerialLossPer90	pAdjDrpPastAttPer90	TouchCentrality	Tkl+IntOppTouch	pAdjTouchesPer90	pAdjCarriesPer90	Main Position
0	William Saliba	fr FRA	DF	Marseille	fr Ligue 1	20	2001	36	36	3240	0	2.4	0	16	3	18.8	0.44	0.08	0.00	0.00	10.3	0	1.5	1.5	0.10	-1.5	-1.5	2865	3058	93.7	56752	16714	925	977	94.7	1575	1631	96.6	349	408	85.5	0	0.8	-0.8	6	184	15	2	166	2965	93	71	2	294	48	6	0	0	2740	152	166	141	2806	48	21	6	2	23	45	24	21	0.58	19	0	0	2	0	0	3	0.08	2	0	1	0	0	65	42	47	15	3	15	32	46.9	17	297	139	46.8	165	115	17	49	17	0	32	80	145	91	2	3351	287	1433	1982	187	37	3267	27	37	73.0	27	4	2532	14149	8367	243	24	3	12	21	2669	2621	98.2	10	5	0	17	13	1	0	312	61	38	61.6	0.000000	0.066667	0.000000	0.444444	0.083333	0.522222	0.012222	0.002222	0.000000	0.000000	0.286111	0.00000	0.041667	0.041667	0.002778	-0.041667	-0.041667	79.583333	84.944444	2.602778	1576.444444	464.277778	25.694444	27.138889	2.630556	43.750000	45.305556	2.683333	9.694444	11.333333	2.375000	0.000000	0.022222	-0.022222	0.166667	5.111111	0.416667	0.055556	4.611111	82.361111	2.583333	1.972222	0.055556	8.166667	1.333333	0.166667	0.00000	0.00000	76.111111	4.222222	4.611111	3.916667	77.944444	1.333333	0.583333	0.166667	0.055556	0.638889	1.250000	0.666667	0.583333	0.016111	0.527778	0.000000	0.000000	0.055556	0.000000	0.000000	0.083333	0.002222	0.055556	0.00000	0.027778	0.000000	0.00000	1.805556	1.166667	1.305556	0.416667	0.083333	0.416667	0.888889	1.302778	0.472222	8.250000	3.861111	1.300000	4.583333	3.194444	0.472222	1.361111	0.472222	0.000000	0.888889	2.222222	4.027778	2.527778	0.055556	93.083333	7.972222	39.805556	55.055556	5.194444	1.027778	90.750000	0.750000	1.027778	2.027778	0.750000	0.111111	70.333333	393.027778	232.416667	6.750000	0.666667	0.083333	0.333333	0.583333	74.138889	72.805556	2.727778	0.277778	0.138889	0.000000	0.472222	0.361111	0.027778	0.000000	8.666667	1.694444	1.055556	61.6	36.000000	62.0	28340	3420	745.789474	3.179825	3.048246	1.995614	0.372807	1.754386	1.425439	1.425439	0.372807	1.337719	0.833333	0.701754	12.481181	3.240414	45.040323	45.335721	Centre-Back
1	João Cancelo	pt POR	DF	Manchester City	eng Premier League	27	1994	36	36	3227	1	9.3	1	81	23	28.4	2.26	0.64	0.01	0.04	21.5	1	4.1	4.1	0.05	-3.1	-3.1	2752	3282	83.9	49380	14430	1304	1412	92.4	1132	1306	86.7	297	482	61.6	7	5.1	1.9	39	266	95	13	274	2944	338	51	6	295	99	103	1	1	2279	492	511	377	2479	97	286	7	9	54	107	70	103	2.87	82	0	7	12	1	1	16	0.45	11	1	3	0	1	89	54	31	36	22	35	83	42.2	48	347	119	34.3	106	138	103	45	4	1	41	75	164	56	0	3714	74	608	1993	1373	119	3387	53	105	50.5	59	12	2705	11821	6458	364	138	35	28	29	2831	2719	96.0	127	7	0	37	37	2	0	349	49	45	52.1	0.027890	0.259374	0.027890	2.259064	0.641463	0.792067	0.063031	0.017849	0.000279	0.001116	0.599628	0.02789	0.114348	0.114348	0.001394	-0.086458	-0.086458	76.752402	91.533932	2.339944	1377.192439	402.448094	36.368144	39.380229	2.577007	31.571119	36.423923	2.418035	8.283235	13.442826	1.718004	0.195228	0.142237	0.052990	1.087698	7.418655	2.649520	0.362566	7.641773	82.107220	9.426712	1.422374	0.167338	8.227456	2.761078	2.872637	0.02789	0.02789	63.560583	13.721723	14.251627	10.514410	69.138519	2.705299	7.976449	0.195228	0.251007	1.506043	2.984196	1.952278	2.872637	0.080043	2.286954	0.000000	0.195228	0.334676	0.027890	0.027890	0.446235	0.012550	0.306786	0.02789	0.083669	0.000000	0.02789	2.482182	1.506043	0.864580	1.004029	0.613573	0.976139	2.314844	1.176945	1.338705	9.677719	3.318872	0.956616	2.956306	3.848776	2.872637	1.255036	0.111559	0.027890	1.143477	2.091726	4.573908	1.561822	0.000000	103.582275	2.063836	16.956926	55.584134	38.292532	3.318872	94.462349	1.478153	2.928416	1.408429	1.645491	0.334676	75.441587	329.683917	180.111559	10.151844	3.848776	0.976139	0.780911	0.808801	78.955686	75.832042	2.677409	3.541989	0.195228	0.000000	1.031918	1.031918	0.055779	0.000000	9.733499	1.366594	1.255036	52.1	35.855556	68.5	31078	3420	817.842105	4.356103	3.160830	1.487450	0.106246	1.992120	2.363982	2.363982	1.274957	1.301518	1.195272	2.204613	12.665314	3.355592	45.364500	43.699515	Right-Back
2	Aymeric Laporte	es ESP	DF	Manchester City	eng Premier League	27	1994	33	33	2828	4	4.9	4	35	7	20.0	1.11	0.22	0.11	0.57	10.7	0	4.4	4.4	0.13	-0.4	-0.4	2703	2853	94.7	58451	16557	757	788	96.1	1450	1497	96.9	482	549	87.8	0	0.5	-0.5	9	316	11	1	198	2798	55	43	3	202	64	5	0	0	2446	144	263	2050	648	91	12	7	1	17	19	6	30	0.95	26	0	0	3	1	0	4	0.13	2	0	1	1	0	31	17	20	10	1	15	25	60.0	10	139	63	45.3	81	50	8	24	11	0	13	33	64	78	2	3059	258	1144	2013	177	43	3006	3	5	60.0	3	0	2285	14300	9587	352	61	1	1	8	2539	2501	98.5	8	5	1	15	13	2	1	288	73	36	67.0	0.127298	0.155941	0.127298	1.113861	0.222772	0.636492	0.035325	0.007001	0.003501	0.018140	0.340523	0.00000	0.140028	0.140028	0.004137	-0.012730	-0.012730	86.021924	90.795615	3.013791	1860.180339	526.920085	24.091231	25.077793	3.058345	46.145686	47.641443	3.083805	15.339463	17.471711	2.794201	0.000000	0.015912	-0.015912	0.286421	10.056577	0.350071	0.031825	6.301273	89.045262	1.750354	1.368458	0.095474	6.428571	2.036775	0.159123	0.00000	0.00000	77.842999	4.582744	8.369873	65.240453	20.622348	2.896040	0.381895	0.222772	0.031825	0.541018	0.604668	0.190948	0.954738	0.030233	0.827440	0.000000	0.000000	0.095474	0.031825	0.000000	0.127298	0.004137	0.063649	0.00000	0.031825	0.031825	0.00000	0.986563	0.541018	0.636492	0.318246	0.031825	0.477369	0.795615	1.909477	0.318246	4.423621	2.004950	1.441655	2.577793	1.591231	0.254597	0.763791	0.350071	0.000000	0.413720	1.050212	2.036775	2.482320	0.063649	97.351485	8.210750	36.407355	64.062942	5.632956	1.368458	95.664781	0.095474	0.159123	1.909477	0.095474	0.000000	72.719236	455.091938	305.102546	11.202263	1.941301	0.031825	0.031825	0.254597	80.802687	79.593352	3.134724	0.254597	0.159123	0.031825	0.477369	0.413720	0.063649	0.031825	9.165488	2.323197	1.145686	67.0	31.422222	68.5	31078	3420	817.842105	1.939786	1.909477	2.364114	0.333401	1.000202	0.939584	0.939584	0.303092	2.212568	1.091130	0.757729	11.903457	1.494255	42.635687	44.818568	Centre-Back
3	Rodri	es ESP	MF	Manchester City	eng Premier League	25	1996	33	33	2884	7	4.1	7	45	14	31.1	1.40	0.44	0.16	0.50	18.2	0	2.7	2.7	0.06	4.3	4.3	2587	2796	92.5	52886	10194	932	983	94.8	1215	1286	94.5	424	491	86.4	2	1.4	0.6	25	242	36	1	179	2755	41	35	2	464	103	8	0	0	2177	234	385	371	2248	102	6	5	5	19	39	15	75	2.34	63	1	2	5	1	3	3	0.09	3	0	0	0	0	65	46	20	36	9	29	61	47.5	32	481	171	35.6	130	254	97	48	6	1	42	40	105	54	0	3096	95	618	1965	698	64	3061	9	18	50.0	10	1	2181	9213	4710	205	44	8	13	28	2457	2382	96.9	61	5	0	50	37	0	0	415	91	33	73.4	0.218447	0.127947	0.218447	1.404300	0.436893	0.970527	0.043689	0.013731	0.004993	0.015603	0.567961	0.00000	0.084258	0.084258	0.001872	0.134189	0.134189	80.731623	87.253814	2.886616	1650.395284	318.120666	29.084605	30.676144	2.958391	37.916089	40.131761	2.949029	13.231623	15.322469	2.696255	0.062413	0.043689	0.018724	0.780166	7.552011	1.123440	0.031207	5.585992	85.974341	1.279473	1.092233	0.062413	14.479889	3.214286	0.249653	0.00000	0.00000	67.936893	7.302358	12.014563	11.577670	70.152566	3.183079	0.187240	0.156033	0.156033	0.592926	1.217060	0.468100	2.340499	0.073024	1.966019	0.031207	0.062413	0.156033	0.031207	0.093620	0.093620	0.002809	0.093620	0.00000	0.000000	0.000000	0.00000	2.028433	1.435506	0.624133	1.123440	0.280860	0.904993	1.903606	1.482316	0.998613	15.010402	5.336338	1.110957	4.056865	7.926491	3.027046	1.497920	0.187240	0.031207	1.310680	1.248266	3.276699	1.685160	0.000000	96.615811	2.964632	19.285714	61.321082	21.782247	1.997226	95.523578	0.280860	0.561720	1.560333	0.312067	0.031207	68.061720	287.506935	146.983356	6.397365	1.373093	0.249653	0.405687	0.873786	76.674757	74.334258	3.023925	1.903606	0.156033	0.000000	1.560333	1.154646	0.000000	0.000000	12.950763	2.839806	1.029820	73.4	32.044444	68.5	31078	3420	817.842105	3.120666	5.082227	1.604914	0.178324	1.188825	1.931841	1.931841	0.951060	2.704577	0.980781	1.812958	11.813504	2.403911	42.313494	42.267442	Defensive Midfield
4	Sergio Busquets	es ESP	MF	Barcelona	es La Liga	33	1988	36	36	3198	2	2.6	2	14	4	28.6	0.39	0.11	0.14	0.50	19.7	0	0.7	0.7	0.05	1.3	1.3	2462	2799	88.0	48573	11342	961	1045	92.0	1043	1148	90.9	407	519	78.4	0	1.9	-1.9	33	260	34	1	223	2690	109	105	5	383	105	4	0	0	2110	251	438	502	2129	96	4	11	17	37	64	23	85	2.39	75	1	1	0	3	5	3	0.08	3	0	0	0	0	95	72	34	49	12	46	85	54.1	39	633	217	34.3	185	343	105	58	8	0	50	57	152	51	0	3109	93	626	2067	547	26	3023	18	20	90.0	18	2	2040	7059	3756	157	38	1	14	20	2373	2293	96.6	67	12	0	69	83	2	0	422	80	66	54.8	0.056285	0.073171	0.056285	0.393996	0.112570	0.804878	0.010976	0.003096	0.003940	0.014071	0.554409	0.00000	0.019700	0.019700	0.001407	0.036585	0.036585	69.287054	78.771107	2.476548	1366.969981	319.193246	27.045028	29.409006	2.589118	29.352720	32.307692	2.558161	11.454034	14.606004	2.206379	0.000000	0.053471	-0.053471	0.928705	7.317073	0.956848	0.028143	6.275797	75.703565	3.067542	2.954972	0.140713	10.778612	2.954972	0.112570	0.00000	0.00000	59.380863	7.063790	12.326454	14.127580	59.915572	2.701689	0.112570	0.309568	0.478424	1.041276	1.801126	0.647280	2.392120	0.067261	2.110694	0.028143	0.028143	0.000000	0.084428	0.140713	0.084428	0.002251	0.084428	0.00000	0.000000	0.000000	0.00000	2.673546	2.026266	0.956848	1.378987	0.337711	1.294559	2.392120	1.522514	1.097561	17.814259	6.106942	0.965291	5.206379	9.652908	2.954972	1.632270	0.225141	0.000000	1.407129	1.604128	4.277674	1.435272	0.000000	87.495310	2.617261	17.617261	58.170732	15.393996	0.731707	85.075047	0.506567	0.562852	2.532833	0.506567	0.056285	57.410882	198.658537	105.703565	4.418386	1.069418	0.028143	0.393996	0.562852	66.782364	64.530957	2.718574	1.885553	0.337711	0.000000	1.941839	2.335835	0.056285	0.000000	11.876173	2.251407	1.857411	54.8	35.533333	64.8	29116	3420	766.210526	3.645744	5.204780	1.223243	0.191881	1.367154	2.278590	2.278590	0.935421	1.918813	1.583021	2.038739	11.419226	3.349737	40.507088	39.369572	Defensive Midfield

In [309]:

#Filter the dataframe by age and minutes played - 26 and younger, and 750 mins played

df = df.loc[(df['Age']<27) & (df['Min']>750) & (df['Main Position']=='Centre-Back')]

In [310]:

df.head()

Out[310]:

	Player	Nation	Pos	Squad	Comp	Age	Born	MP	Starts	Min	npGoals	npxG+xA	Goals	Shots	SoT	SoT%	Sh/90	SoT/90	G/Sh	G/SoT	AvgShotDistance	xG	npxG	npxG/Sh	G-xG	npG-xG	PassesCompleted	PassesAttempted	TotCmp%	TotalPassDist	ProgPassDist	ShortPassCmp	ShortPassAtt	ShortPassCmp%	MedPassCmp	MedPassAtt	MedPassCmp%	LongPassCmp	LongPassAtt	LongPassCmp%	Assists	xA	A-xA	KeyPasses	Final1/3Cmp	PenAreaCmp	CrsPenAreaCmp	ProgPasses	LivePass	DeadPass	FKPasses	ThruBalls	PassUnderPress	Switches	Crs	Ground	Low	High	Left	Right	Head	ThrowIn	Other	PassesToOff	PassesOOB	PassesInt	PassesBlocked	SCA	SCA90	SCAPassLive	SCAPassDead	SCASh	SCADef	GCA	GCA90	GCAPassLive	GCASh	DrbTkl	TklWinPoss	Def3rdPress	Mid3rdPress	Att3rdPress	DrbTkl.1	DrpPastAtt	DrbTkl%	DrbPast	Press	PressSucc	PressSucc%	Def3rdPress.1	Mid3rdPress.1	Att3rdPress.1	Blocks	ShBlocks	PassBlocks	Int	Tkl+Int	Clr	Err	Touches	DefPenTouch	Def3rdTouch	Mid3rdTouch	Att3rdTouch	AttPenTouch	LiveTouch	SuccDrb	AttDrb	DrbSucc%	PlDrbPast	Megs	Carries	TotCarryDist	PrgCarryDist	ProgCarries	CarriesToFinal3rd	CarriesToPenArea	CarryMistakes	Disposesed	PassTarget	ReceivedPass	Receive%	ProgPassesRec	Yellows	Fls	Fld	Off	PKcon	Recov	AerialWins	AerialLoss	AerialWin%	npGoalsPer90	npxG+xAPer90	GoalsPer90	ShotsPer90	SoTPer90	SoT%Per90	Sh/90Per90	SoT/90Per90	G/ShPer90	G/SoTPer90	AvgShotDistancePer90	xGPer90	npxGPer90	npxG/ShPer90	G-xGPer90	npG-xGPer90	PassesCompletedPer90	PassesAttemptedPer90	TotCmp%Per90	TotalPassDistPer90	ProgPassDistPer90	ShortPassCmpPer90	ShortPassAttPer90	ShortPassCmp%Per90	MedPassCmpPer90	MedPassAttPer90	MedPassCmp%Per90	LongPassCmpPer90	LongPassAttPer90	LongPassCmp%Per90	AssistsPer90	xAPer90	A-xAPer90	KeyPassesPer90	Final1/3CmpPer90	PenAreaCmpPer90	CrsPenAreaCmpPer90	ProgPassesPer90	LivePassPer90	DeadPassPer90	FKPassesPer90	ThruBallsPer90	PassUnderPressPer90	SwitchesPer90	CrsPer90	GroundPer90	LowPer90	HighPer90	LeftPer90	RightPer90	HeadPer90	ThrowInPer90	OtherPer90	PassesToOffPer90	PassesOOBPer90	PassesIntPer90	PassesBlockedPer90	SCAPer90	SCA90Per90	GCAPassLivePer90	GCAPassDeadPer90	GCAShPer90	GCADefPer90	GCAPer90	GCA90Per90	GCAPassLive.1Per90	GCASh.1Per90	DrbTklPer90	TklWinPossPer90	Def3rdPressPer90	Mid3rdPressPer90	Att3rdPressPer90	DrbTkl.1Per90	DrpPastAttPer90	DrbTkl%Per90	DrbPastPer90	PressPer90	PressSuccPer90	PressSucc%Per90	Def3rdPress.1Per90	Mid3rdPress.1Per90	Att3rdPress.1Per90	BlocksPer90	ShBlocksPer90	PassBlocksPer90	IntPer90	Tkl+IntPer90	ClrPer90	ErrPer90	TouchesPer90	DefPenTouchPer90	Def3rdTouchPer90	Mid3rdTouchPer90	Att3rdTouchPer90	AttPenTouchPer90	LiveTouchPer90	SuccDrbPer90	AttDrbPer90	DrbSucc%Per90	PlDrbPastPer90	MegsPer90	CarriesPer90	TotCarryDistPer90	PrgCarryDistPer90	ProgCarriesPer90	CarriesToFinal3rdPer90	CarriesToPenAreaPer90	CarryMistakesPer90	DisposesedPer90	PassTargetPer90	ReceivedPassPer90	Receive%Per90	ProgPassesRecPer90	YellowsPer90	FlsPer90	FldPer90	OffPer90	PKconPer90	RecovPer90	AerialWinsPer90	AerialLossPer90	AerialWin%Per90	90sPer90	AvgTeamPoss	OppTouches	TeamMins	TeamTouches90	pAdjTkl+IntPer90	pAdjPressSuccPer90	pAdjClrPer90	pAdjShBlocksPer90	pAdjIntPer90	pAdjDrbTklPer90	pAdjTklWinPossPer90	pAdjDrbPastPer90	pAdjAerialWinsPer90	pAdjAerialLossPer90	pAdjDrpPastAttPer90	TouchCentrality	Tkl+IntOppTouch	pAdjTouchesPer90	pAdjCarriesPer90	Main Position
0	William Saliba	fr FRA	DF	Marseille	fr Ligue 1	20	2001	36	36	3240	0	2.4	0	16	3	18.8	0.44	0.08	0.00	0.00	10.3	1.5	1.5	0.10	-1.5	-1.5	2865	3058	93.7	56752	16714	925	977	94.7	1575	1631	96.6	349	408	85.5	0	0.8	-0.8	6	184	15	2	166	2965	93	71	2	294	48	6	2740	152	166	141	2806	48	21	6	2	23	45	24	21	0.58	19	0	2	0	3	0.08	2	1	65	42	47	15	3	15	32	46.9	17	297	139	46.8	165	115	17	49	17	32	80	145	91	2	3351	287	1433	1982	187	37	3267	27	37	73.0	27	4	2532	14149	8367	243	24	3	12	21	2669	2621	98.2	10	5	17	13	1	0	312	61	38	61.6	0.000000	0.066667	0.000000	0.444444	0.083333	0.522222	0.012222	0.002222	0.000000	0.000000	0.286111	0.041667	0.041667	0.002778	-0.041667	-0.041667	79.583333	84.944444	2.602778	1576.444444	464.277778	25.694444	27.138889	2.630556	43.750000	45.305556	2.683333	9.694444	11.333333	2.375000	0.000000	0.022222	-0.022222	0.166667	5.111111	0.416667	0.055556	4.611111	82.361111	2.583333	1.972222	0.055556	8.166667	1.333333	0.166667	76.111111	4.222222	4.611111	3.916667	77.944444	1.333333	0.583333	0.166667	0.055556	0.638889	1.250000	0.666667	0.583333	0.016111	0.527778	0.000000	0.055556	0.000000	0.083333	0.002222	0.055556	0.027778	1.805556	1.166667	1.305556	0.416667	0.083333	0.416667	0.888889	1.302778	0.472222	8.250000	3.861111	1.300000	4.583333	3.194444	0.472222	1.361111	0.472222	0.888889	2.222222	4.027778	2.527778	0.055556	93.083333	7.972222	39.805556	55.055556	5.194444	1.027778	90.750000	0.750000	1.027778	2.027778	0.750000	0.111111	70.333333	393.027778	232.416667	6.750000	0.666667	0.083333	0.333333	0.583333	74.138889	72.805556	2.727778	0.277778	0.138889	0.472222	0.361111	0.027778	0.000000	8.666667	1.694444	1.055556	61.6	36.000000	62.0	28340	3420	745.789474	3.179825	3.048246	1.995614	0.372807	1.754386	1.425439	1.425439	0.372807	1.337719	0.833333	0.701754	12.481181	3.240414	45.040323	45.335721	Centre-Back
14	Presnel Kimpembe	fr FRA	DF	Paris S-G	fr Ligue 1	25	1995	30	29	2576	1	1.0	1	7	1	14.3	0.24	0.03	0.14	1.00	9.1	0.9	0.9	0.12	0.1	0.1	2170	2242	96.8	40135	12618	849	870	97.6	1080	1104	97.8	215	233	92.3	0	0.1	-0.1	3	157	5	2	103	2163	79	53	0	156	25	2	2034	129	79	1872	265	48	25	2	0	8	12	8	18	0.63	16	2	0	0	3	0.10	3	0	39	21	23	14	2	14	24	58.3	10	198	54	27.3	99	81	18	27	16	11	54	93	83	1	2460	275	942	1569	104	14	2395	8	13	61.5	9	0	1822	9854	5459	135	15	2	7	5	1983	1957	98.7	10	6	30	27	0	2	203	54	22	71.1	0.034938	0.034938	0.034938	0.244565	0.034938	0.499612	0.008385	0.001048	0.004891	0.034938	0.317935	0.031444	0.031444	0.004193	0.003494	0.003494	75.815217	78.330745	3.381988	1402.232143	440.846273	29.662267	30.395963	3.409938	37.732919	38.571429	3.416925	7.511646	8.140528	3.224767	0.000000	0.003494	-0.003494	0.104814	5.485248	0.174689	0.069876	3.598602	75.570652	2.760093	1.851708	0.000000	5.450311	0.873447	0.069876	71.063665	4.506988	2.760093	65.403727	9.258540	1.677019	0.873447	0.069876	0.000000	0.279503	0.419255	0.279503	0.628882	0.022011	0.559006	0.069876	0.000000	0.000000	0.104814	0.003494	0.104814	0.000000	1.362578	0.733696	0.803571	0.489130	0.069876	0.489130	0.838509	2.036879	0.349379	6.917702	1.886646	0.953804	3.458851	2.829969	0.628882	0.943323	0.559006	0.384317	1.886646	3.249224	2.899845	0.034938	85.947205	9.607919	32.911491	54.817547	3.633540	0.489130	83.676242	0.279503	0.454193	2.148680	0.314441	0.000000	63.656832	344.277950	190.725932	4.716615	0.524068	0.069876	0.244565	0.174689	69.281832	68.373447	3.448370	0.349379	0.209627	1.048137	0.943323	0.000000	0.069876	7.092391	1.886646	0.768634	71.1	28.622222	63.4	30676	3420	807.263158	2.663298	1.546431	2.376922	0.458202	1.546431	1.116867	1.116867	0.286376	1.546431	0.630027	0.687303	10.646739	2.414992	40.669024	44.439024	Centre-Back
18	Jean-Clair Todibo	fr FRA	DF	Nice	fr Ligue 1	21	1999	36	35	3115	1	3.2	1	20	6	30.0	0.58	0.17	0.05	0.17	9.1	2.4	2.4	0.13	-1.4	-1.4	2103	2396	87.8	45438	13840	545	596	91.4	1228	1293	95.0	323	479	67.4	0	0.8	-0.8	14	169	9	1	129	2324	72	65	3	218	48	4	1927	131	338	148	2099	96	7	8	6	41	41	22	30	0.87	25	1	4	0	4	0.12	2	2	77	47	54	21	2	37	67	55.2	30	380	151	39.7	221	144	15	55	22	33	79	156	134	0	2755	285	1240	1589	90	30	2684	9	15	60.0	10	0	1957	11333	5701	175	20	0	8	8	1991	1971	99.0	8	6	26	10	0	1	326	74	54	57.8	0.028892	0.092456	0.028892	0.577849	0.173355	0.866774	0.016758	0.004912	0.001445	0.004912	0.262921	0.069342	0.069342	0.003756	-0.040449	-0.040449	60.760835	69.226324	2.536758	1312.815409	399.871589	15.746388	17.219904	2.640770	35.479936	37.357945	2.744783	9.332263	13.839486	1.947352	0.000000	0.023114	-0.023114	0.404494	4.882825	0.260032	0.028892	3.727127	67.146067	2.080257	1.878010	0.086677	6.298555	1.386838	0.115570	55.675762	3.784912	9.765650	4.276083	60.645265	2.773676	0.202247	0.231140	0.173355	1.184591	1.184591	0.635634	0.866774	0.025136	0.722311	0.028892	0.115570	0.000000	0.115570	0.003467	0.057785	0.057785	2.224719	1.357945	1.560193	0.606742	0.057785	1.069021	1.935795	1.594864	0.866774	10.979133	4.362761	1.147030	6.385233	4.160514	0.433387	1.589085	0.635634	0.953451	2.282504	4.507223	3.871589	0.000000	79.598716	8.234350	35.826645	45.910112	2.600321	0.866774	77.547352	0.260032	0.433387	1.733547	0.288925	0.000000	56.542536	327.438202	164.715891	5.056180	0.577849	0.000000	0.231140	0.231140	57.524880	56.947030	2.860353	0.231140	0.173355	0.751204	0.288925	0.000000	0.028892	9.418941	2.138042	1.560193	57.8	34.611111	51.6	24008	3420	631.789474	2.793733	2.704191	2.399745	0.393988	1.414775	1.378958	1.378958	0.537256	1.325232	0.967062	1.199873	12.598930	4.280435	46.278323	42.620690	Centre-Back
20	Rúben Dias	pt POR	DF	Manchester City	eng Premier League	24	1997	29	27	2402	2	4.6	2	18	4	22.2	0.67	0.15	0.11	0.50	10.6	2.2	2.2	0.12	-0.2	-0.2	2097	2224	94.3	45031	11468	566	594	95.3	1189	1224	97.1	336	389	86.4	4	2.4	1.6	12	182	4	0	106	2175	49	36	3	161	46	5	1924	102	198	341	1769	64	12	4	2	13	18	11	30	1.12	26	0	3	1	6	0.22	4	2	34	27	12	18	4	7	16	43.8	9	153	68	44.4	57	78	18	28	13	15	38	72	78	1	2427	178	877	1634	111	32	2380	2	5	40.0	2	1	1792	10636	6630	239	22	0	5	2	1981	1952	98.5	8	5	30	10	2	0	217	53	36	59.6	0.074938	0.172356	0.074938	0.674438	0.149875	0.831807	0.025104	0.005620	0.004122	0.018734	0.397169	0.082431	0.082431	0.004496	-0.007494	-0.007494	78.572023	83.330558	3.533306	1687.256453	429.691923	21.207327	22.256453	3.570774	44.550375	45.861782	3.638218	12.589509	14.575354	3.237302	0.149875	0.089925	0.059950	0.449625	6.819317	0.149875	0.000000	3.971690	81.494588	1.835970	1.348876	0.112406	6.032473	1.723564	0.187344	72.089925	3.821815	7.418818	12.776853	66.282265	2.398002	0.449625	0.149875	0.074938	0.487094	0.674438	0.412157	1.124063	0.041965	0.974188	0.000000	0.112406	0.037469	0.224813	0.008243	0.149875	0.074938	1.273938	1.011657	0.449625	0.674438	0.149875	0.262281	0.599500	1.641132	0.337219	5.732723	2.547877	1.663614	2.135720	2.922565	0.674438	1.049126	0.487094	0.562032	1.423813	2.697752	2.922565	0.037469	90.936719	6.669442	32.860117	61.223980	4.159034	1.199001	89.175687	0.074938	0.187344	1.498751	0.074938	0.037469	67.144047	398.517902	248.417985	8.955037	0.824313	0.000000	0.187344	0.074938	74.225645	73.139051	3.690674	0.299750	0.187344	1.124063	0.374688	0.074938	0.000000	8.130724	1.985845	1.348876	59.6	26.688889	68.5	31078	3420	817.842105	2.569287	2.426549	2.783395	0.463899	1.356013	1.213275	1.213275	0.321161	1.891281	1.284644	0.570953	11.119105	1.979173	39.826300	44.301607	Centre-Back
24	Dayot Upamecano	fr FRA	DF	Bayern Munich	de Bundesliga	22	1998	28	25	2211	1	2.1	1	10	1	10.0	0.41	0.04	0.10	1.00	12.3	0.8	0.8	0.08	0.2	0.2	2048	2262	90.5	45957	13906	507	542	93.5	1122	1203	93.3	407	490	83.1	6	1.4	4.6	10	184	11	0	143	2218	44	31	2	275	58	4	1839	162	261	260	1889	56	12	3	3	24	50	18	23	0.94	20	0	1	2	6	0.24	6	0	58	33	38	19	1	18	32	56.3	14	358	148	41.3	173	162	23	34	10	24	69	127	75	3	2501	215	1069	1483	145	23	2459	10	11	90.9	10	1	1898	10773	5477	137	31	2	6	14	1888	1858	98.4	7	4	33	14	1	1	332	74	51	59.2	0.040706	0.085482	0.040706	0.407056	0.040706	0.407056	0.016689	0.001628	0.004071	0.040706	0.500678	0.032564	0.032564	0.003256	0.008141	0.008141	83.364993	92.075984	3.683853	1870.705563	566.051560	20.637720	22.062415	3.805970	45.671642	48.968792	3.797829	16.567164	19.945726	3.382632	0.244233	0.056988	0.187246	0.407056	7.489824	0.447761	0.000000	5.820896	90.284939	1.791045	1.261872	0.081411	11.194030	2.360923	0.162822	74.857531	6.594301	10.624152	10.583446	76.892809	2.279512	0.488467	0.122117	0.122117	0.976934	2.035278	0.732700	0.936228	0.038263	0.814111	0.000000	0.040706	0.081411	0.244233	0.009769	0.244233	0.000000	2.360923	1.343284	1.546811	0.773406	0.040706	0.732700	1.302578	2.291723	0.569878	14.572592	6.024423	1.681140	7.042062	6.594301	0.936228	1.383989	0.407056	0.976934	2.808684	5.169607	3.052917	0.122117	101.804613	8.751696	43.514247	60.366350	5.902307	0.936228	100.094980	0.407056	0.447761	3.700136	0.407056	0.040706	77.259159	438.521031	222.944369	5.576662	1.261872	0.081411	0.244233	0.569878	76.852103	75.630936	4.005427	0.284939	0.162822	1.343284	0.569878	0.040706	0.040706	13.514247	3.012212	2.075984	59.2	24.566667	64.8	27862	3060	819.470588	4.405915	5.134452	2.601918	0.346922	2.393765	2.012150	2.012150	0.485691	2.567226	1.769304	1.110152	12.423217	3.785083	47.131765	45.533786	Centre-Back

In [311]:

#Seperating dataframe for player key information

df1 = df.filter(['Player','Squad','Main Position','Comp','Mins','Age'], axis=1)

In [312]:

#Convert all numeric values to Z-Scores
numeric_cols = df.select_dtypes(include=[np.number]).columns

df2 = df[numeric_cols].apply(zscore)

In [313]:

df2.head()

Out[313]:

	Age	Born	MP	Starts	Min	npGoals	npxG+xA	Goals	Shots	SoT	SoT%	Sh/90	SoT/90	G/Sh	G/SoT	AvgShotDistance	FKShots	PK	PKsAtt	xG	npxG	npxG/Sh	G-xG	npG-xG	PassesCompleted	PassesAttempted	TotCmp%	TotalPassDist	ProgPassDist	ShortPassCmp	ShortPassAtt	ShortPassCmp%	MedPassCmp	MedPassAtt	MedPassCmp%	LongPassCmp	LongPassAtt	LongPassCmp%	Assists	xA	A-xA	KeyPasses	Final1/3Cmp	PenAreaCmp	CrsPenAreaCmp	ProgPasses	LivePass	DeadPass	FKPasses	ThruBalls	PassUnderPress	Switches	Crs	CK	InSwingCK	OutSwingCK	StrCK	Ground	Low	High	Left	Right	Head	ThrowIn	Other	PassesToOff	PassesOOB	PassesInt	PassesBlocked	SCA	SCA90	SCAPassLive	SCAPassDead	SCADrib	SCASh	SCAFld	SCADef	GCA	GCA90	GCAPassLive	GCAPassDead	GCADrib	GCASh	GCAFld	GCADef	DrbTkl	TklWinPoss	Def3rdPress	Mid3rdPress	Att3rdPress	DrbTkl.1	DrpPastAtt	DrbTkl%	DrbPast	Press	PressSucc	PressSucc%	Def3rdPress.1	Mid3rdPress.1	Att3rdPress.1	Blocks	ShBlocks	ShSvBlocks	PassBlocks	Int	Tkl+Int	Clr	Err	Touches	DefPenTouch	Def3rdTouch	Mid3rdTouch	Att3rdTouch	AttPenTouch	LiveTouch	SuccDrb	AttDrb	DrbSucc%	PlDrbPast	Megs	Carries	TotCarryDist	PrgCarryDist	ProgCarries	CarriesToFinal3rd	CarriesToPenArea	CarryMistakes	Disposesed	PassTarget	ReceivedPass	Receive%	ProgPassesRec	Yellows	Reds	Yellow2	Fls	Fld	Off	PKwon	PKcon	OG	Recov	AerialWins	AerialLoss	AerialWin%	npGoalsPer90	npxG+xAPer90	GoalsPer90	ShotsPer90	SoTPer90	SoT%Per90	Sh/90Per90	SoT/90Per90	G/ShPer90	G/SoTPer90	AvgShotDistancePer90	FKShotsPer90	PKPer90	PKsAttPer90	xGPer90	npxGPer90	npxG/ShPer90	G-xGPer90	npG-xGPer90	PassesCompletedPer90	PassesAttemptedPer90	TotCmp%Per90	TotalPassDistPer90	ProgPassDistPer90	ShortPassCmpPer90	ShortPassAttPer90	ShortPassCmp%Per90	MedPassCmpPer90	MedPassAttPer90	MedPassCmp%Per90	LongPassCmpPer90	LongPassAttPer90	LongPassCmp%Per90	AssistsPer90	xAPer90	A-xAPer90	KeyPassesPer90	Final1/3CmpPer90	PenAreaCmpPer90	CrsPenAreaCmpPer90	ProgPassesPer90	LivePassPer90	DeadPassPer90	FKPassesPer90	ThruBallsPer90	PassUnderPressPer90	SwitchesPer90	CrsPer90	CKPer90	InSwingCKPer90	OutSwingCKPer90	StrCKPer90	GroundPer90	LowPer90	HighPer90	LeftPer90	RightPer90	HeadPer90	ThrowInPer90	OtherPer90	PassesToOffPer90	PassesOOBPer90	PassesIntPer90	PassesBlockedPer90	SCAPer90	SCA90Per90	GCAPassLivePer90	GCAPassDeadPer90	GCADribPer90	GCAShPer90	GCAFldPer90	GCADefPer90	GCAPer90	GCA90Per90	GCAPassLive.1Per90	GCAPassDead.1Per90	GCADrib.1Per90	GCASh.1Per90	GCAFld.1Per90	GCADef.1Per90	DrbTklPer90	TklWinPossPer90	Def3rdPressPer90	Mid3rdPressPer90	Att3rdPressPer90	DrbTkl.1Per90	DrpPastAttPer90	DrbTkl%Per90	DrbPastPer90	PressPer90	PressSuccPer90	PressSucc%Per90	Def3rdPress.1Per90	Mid3rdPress.1Per90	Att3rdPress.1Per90	BlocksPer90	ShBlocksPer90	ShSvBlocksPer90	PassBlocksPer90	IntPer90	Tkl+IntPer90	ClrPer90	ErrPer90	TouchesPer90	DefPenTouchPer90	Def3rdTouchPer90	Mid3rdTouchPer90	Att3rdTouchPer90	AttPenTouchPer90	LiveTouchPer90	SuccDrbPer90	AttDrbPer90	DrbSucc%Per90	PlDrbPastPer90	MegsPer90	CarriesPer90	TotCarryDistPer90	PrgCarryDistPer90	ProgCarriesPer90	CarriesToFinal3rdPer90	CarriesToPenAreaPer90	CarryMistakesPer90	DisposesedPer90	PassTargetPer90	ReceivedPassPer90	Receive%Per90	ProgPassesRecPer90	YellowsPer90	RedsPer90	Yellow2Per90	FlsPer90	FldPer90	OffPer90	PKwonPer90	PKconPer90	OGPer90	RecovPer90	AerialWinsPer90	AerialLossPer90	AerialWin%Per90	90sPer90	AvgTeamPoss	OppTouches	TeamMins	TeamTouches90	pAdjTkl+IntPer90	pAdjPressSuccPer90	pAdjClrPer90	pAdjShBlocksPer90	pAdjIntPer90	pAdjDrbTklPer90	pAdjTklWinPossPer90	pAdjDrbPastPer90	pAdjAerialWinsPer90	pAdjAerialLossPer90	pAdjDrpPastAttPer90	TouchCentrality	Tkl+IntOppTouch	pAdjTouchesPer90	pAdjCarriesPer90
0	-1.438114	1.566817	1.589035	1.694611	1.786744	-0.845654	0.882619	-0.841736	0.677599	-0.046409	-0.435848	-0.248492	-0.532982	-0.788455	-0.873346	-0.423669	-0.182162	-0.071982	-0.071982	0.562822	0.588799	0.162595	-1.793290	-1.795410	3.754109	3.499930	1.560630	3.288333	2.881444	3.956086	3.888252	1.206899	3.896096	3.788502	1.284816	1.802938	1.234781	1.648001	-0.581474	0.673230	-1.215456	0.226623	2.899841	2.000458	0.438782	3.019775	3.548216	0.646244	2.018400	1.263400	3.005099	0.672983	0.055993	-0.166992	-0.140762	-0.125327	-0.071982	4.073956	0.950650	-0.336206	-0.525663	4.221917	-0.298052	-0.115016	0.892059	-0.199097	0.361179	1.771920	1.030736	0.688348	-0.263568	0.929002	-0.574705	-0.4142	0.758852	-0.527764	-0.761324	0.996616	0.188630	0.678691	-0.16265	-0.145095	1.693913	-0.245172	-0.20739	1.369675	1.548922	1.875018	0.277102	0.403771	-0.098408	0.161970	-0.636683	0.430380	0.729048	1.607413	2.405137	0.829350	0.593671	0.153126	0.649699	0.066949	-0.631501	0.874040	1.498289	1.573852	0.044387	1.269001	3.239515	1.073058	2.219063	3.857795	1.406746	1.495431	3.284019	3.198268	2.626630	0.444576	2.994709	3.821727	3.821373	3.672311	3.932787	4.347249	1.156983	1.039596	0.770527	2.631663	3.751316	3.735688	0.477307	0.460615	0.117236	-0.526057	-0.380188	-0.656888	-0.261574	0.169210	-0.211857	-0.830183	-0.42621	1.374241	0.114638	0.193339	-0.003890	-0.806809	-0.025079	-0.807099	-0.231187	-0.500879	-0.616937	-0.643980	-0.609652	-0.546361	-0.701501	-0.970912	-0.172332	-0.071982	-0.071982	-0.154827	-0.147384	-0.643835	-0.943254	-0.942782	2.407794	2.278557	-0.959528	2.066043	1.637109	2.151481	2.103975	-1.023179	2.595767	2.559661	-1.010325	0.638503	-0.036163	-0.774181	-0.599868	0.035340	-0.737860	-0.386825	1.499472	0.804038	0.034863	1.464493	2.318562	-0.167792	0.771750	0.523424	1.418745	-0.185116	-0.261494	-0.12408	-0.112669	-0.109024	-0.071982	2.637636	-0.316554	-1.574093	-0.725110	2.618764	-1.618100	-0.325428	0.013298	-0.640232	-0.754819	0.466957	-0.054900	-0.254205	-0.735684	-0.043045	-0.457762	-0.376863	0.182883	-0.513879	-0.693455	0.235463	-0.308691	0.051687	-0.141863	-0.144114	0.941434	-0.229293	-0.202293	-0.079340	0.112918	0.393999	-0.658964	-0.183097	-1.041918	-0.890747	-1.099943	-0.559795	-0.734842	0.034650	-0.707515	-0.675216	-0.613466	-0.443594	-1.012205	-0.901071	-0.578561	-0.403011	0.114063	0.020876	-1.291616	0.370236	2.177090	-0.184438	1.091671	2.401272	0.247821	0.305785	2.227168	1.408432	1.017489	-0.622037	1.254494	2.119539	2.452703	2.384360	2.515016	2.489188	0.192618	0.287556	-0.039920	0.989620	2.387644	2.378399	-1.075337	-0.077409	-0.716311	-0.503643	-0.348982	-1.683907	-0.904076	-0.166218	-0.203009	-0.785421	-0.3941	-0.383227	-1.096203	-1.054753	-0.003890	1.786744	1.669668	1.822342	0.573382	1.621698	1.052685	0.855035	-0.727319	-0.504849	1.023902	0.689719	0.689719	-0.130970	-0.517065	-0.481432	-0.430559	1.662893	-0.701185	1.499265	2.004544
14	0.918255	-1.196478	0.727537	0.845116	0.855030	0.013283	-0.499846	0.004361	-0.587735	-0.766683	-0.698894	-1.013083	-0.972976	0.567748	2.188257	-0.693666	-0.182162	-0.071982	-0.071982	-0.191061	-0.184747	0.594698	0.195410	0.197778	2.347462	1.977932	2.075504	1.735281	1.671810	3.474000	3.242616	1.885901	2.063844	1.904891	1.531176	0.407399	-0.162952	2.304395	-0.581474	-0.705723	-0.222919	-0.510219	2.235273	0.006168	0.438782	1.177614	2.006851	0.347079	1.050499	-0.697397	0.504166	-0.362840	-0.449245	-0.166992	-0.140762	-0.125327	-0.071982	2.528072	0.498240	-1.237632	3.504038	-0.866631	-0.298052	-0.025134	-0.593430	-1.152794	-1.110853	-0.866794	-0.709016	0.358892	-0.122319	0.538055	1.611427	-0.4142	-0.774661	-0.527764	-0.761324	0.996616	0.491062	1.476666	-0.16265	-0.145095	-0.426210	-0.245172	-0.20739	-0.048355	-0.263864	-0.146771	0.139614	-0.076791	-0.215532	-0.365026	0.460557	-0.482833	-0.288029	-0.780967	-2.063959	-0.441321	-0.178992	0.239986	-0.771580	-0.053311	-0.631501	-1.058049	0.307214	0.158409	-0.139317	0.174840	1.749795	0.944780	0.686874	2.621354	0.203483	-0.468835	1.786855	0.164605	0.224904	-0.039206	0.239103	-0.420991	2.184572	1.978344	1.955921	1.751388	0.243327	0.515747	-0.051708	-0.392655	2.272305	2.289782	0.698620	0.460615	0.478247	-0.526057	-0.380188	0.374022	1.034840	-0.742644	-0.211857	1.946635	-0.42621	0.002918	-0.132079	-0.805203	1.134194	-0.141905	-0.823300	-0.147579	-0.995932	-0.926455	-0.632496	-0.810899	-0.744185	0.109108	1.096004	-0.885567	-0.172332	-0.071982	-0.071982	-0.494390	-0.493278	-0.189231	0.174951	0.176514	2.137929	1.793168	-0.570700	1.466529	1.379870	2.876443	2.686971	-0.657942	1.818990	1.670985	-0.668628	-0.142434	-1.019185	-0.262070	-0.599868	-0.765321	-0.177374	-0.732960	1.765455	-0.247880	0.170985	0.610887	1.817111	-0.083156	0.572852	-0.725486	-0.314919	-0.792095	-0.500748	-0.12408	-0.112669	-0.109024	-0.071982	2.269428	-0.171568	-2.223212	2.765315	-1.271201	-1.165256	-0.191897	-0.836624	-1.348162	-1.870519	-1.496200	-1.065457	-0.125515	-0.518066	0.060433	0.844422	-0.376863	-0.814433	-0.513879	-0.693455	0.559845	-0.012551	0.921189	-0.141863	-0.144114	-0.405214	-0.229293	-0.202293	-0.811741	-0.964475	-0.863237	-0.403286	-0.316007	-0.803804	-0.981728	-0.581543	-0.950157	-1.155234	-1.704603	-1.080726	-1.360541	-0.844524	-0.169194	-1.946178	-0.634614	-0.578561	-1.679459	-0.451103	-0.802480	-0.974960	-0.106228	1.632404	0.547336	0.037066	2.376790	-0.197921	-0.869565	1.683184	-0.158581	-0.113005	-0.559227	-0.115905	-0.410730	1.915990	1.717152	1.610181	1.194891	-0.140300	0.167247	-0.325658	-0.632202	2.023540	2.045282	-0.765315	0.095503	-0.102378	-0.503643	-0.348982	-0.311391	0.590372	-0.742312	-0.203009	1.071647	-0.3941	-1.289775	-0.878342	-1.581184	1.134194	0.855030	1.877041	2.566906	0.573382	2.364826	0.271981	-1.041442	-0.141885	-0.041155	0.516007	-0.077939	-0.077939	-0.580554	-0.177244	-1.050879	-0.471933	0.119759	-1.459345	0.563698	1.805887
18	-0.966840	0.645718	1.589035	1.573254	1.611346	0.013283	1.672599	0.004361	1.239969	1.034000	0.218843	0.286722	0.259007	-0.304097	-0.352873	-0.693666	-0.182162	-0.071982	-0.071982	1.693647	1.749119	0.810749	-1.668997	-1.670836	2.211857	2.265172	0.580710	2.230908	2.032692	1.545657	1.589303	0.434242	2.611669	2.580417	0.956337	1.532162	1.801861	-0.099166	-0.581474	0.673230	-1.215456	2.191538	2.530637	0.803884	-0.036769	1.937871	2.316278	0.197497	1.695766	2.243798	1.627774	0.672983	-0.196626	-0.166992	-0.140762	-0.125327	-0.071982	2.293781	0.537580	1.445925	-0.509368	2.806095	1.683003	-0.429600	1.634804	1.708297	2.127617	1.452076	0.813267	1.676715	0.555678	1.710894	0.518361	-0.4142	2.292365	-0.527764	-0.761324	1.658751	0.793494	0.678691	-0.16265	-0.145095	3.814037	-0.245172	-0.20739	2.024151	1.980538	2.464706	1.102030	-0.076791	2.478313	2.467576	0.162185	2.126347	1.581750	1.944596	0.777928	1.907495	1.252707	-0.020596	1.037321	0.668253	-0.631501	0.966044	1.452478	1.873273	1.031797	-0.919321	2.243025	1.051678	1.616797	2.681230	0.000523	0.897611	2.283048	0.324271	0.425048	-0.102307	0.392192	-0.420991	2.495795	2.561668	2.120434	2.712818	0.750914	-0.531949	0.112739	0.174405	2.289553	2.320268	0.831408	0.203836	0.478247	-0.526057	-0.380188	0.056819	-0.539377	-0.742644	-0.211857	0.558226	-0.42621	1.550375	0.572827	1.191881	-0.459124	-0.256956	0.623716	-0.261699	0.279224	0.290744	-0.379840	-0.446686	-0.301475	-0.352771	-0.448800	-1.033103	-0.172332	-0.071982	-0.071982	0.764461	0.789044	-0.329499	-0.913114	-0.912613	1.059766	1.124982	-0.992473	1.158820	0.930035	0.333869	0.328540	-1.018392	1.528140	1.510847	-0.981703	0.508926	0.735448	-1.031904	-0.599868	0.073463	-0.764547	0.944082	1.337178	0.123120	-0.218586	0.719241	1.194985	-0.408673	0.616261	1.223054	0.226458	-0.114499	-0.387798	-0.12408	-0.112669	-0.109024	-0.071982	1.146889	-0.539208	0.233511	-0.704708	1.639040	0.279712	-0.500830	0.579435	0.860855	0.939292	0.312387	-0.135900	0.546604	-0.402777	0.601557	0.080669	-0.376863	1.260240	-0.513879	-0.693455	0.722278	-0.018768	0.091039	-0.141863	-0.144114	2.396159	-0.229293	-0.202293	0.613687	0.588891	1.031747	0.011688	-0.435418	1.101696	0.999858	-0.893681	0.693981	0.126306	0.476539	-0.872421	0.422966	-0.001031	-0.511617	-0.502565	-0.399340	-0.578561	-0.239684	0.215588	0.527910	-0.147936	-0.913625	1.147837	-0.067168	0.483006	1.460572	-0.492974	-0.045532	1.211863	-0.223430	-0.154011	-0.774893	-0.196187	-0.410730	1.344083	1.486678	1.045672	1.411032	-0.014741	-0.457435	-0.368873	-0.408163	1.142192	1.186471	-1.018299	-0.190036	-0.417185	-0.503643	-0.348982	-1.019039	-1.089367	-0.742312	-0.203009	-0.017555	-0.3941	0.049971	-0.593385	-0.128869	-0.459124	1.611346	0.129188	0.441582	0.573382	0.243604	0.469128	0.420566	-0.106843	-0.389836	0.194459	0.574086	0.574086	0.724440	-0.537396	-0.106867	0.995506	1.761944	0.254086	1.764227	1.403048
20	0.446981	-0.275380	0.583954	0.602403	0.610876	0.872220	3.055064	0.850459	0.958784	0.313727	-0.237103	0.630788	0.083009	0.277133	0.657456	-0.356169	-0.182162	-0.071982	-0.071982	1.442352	1.491270	0.594698	-0.177471	-0.175945	2.199713	1.944359	1.660283	2.192869	1.332191	1.678865	1.577235	1.347383	2.467310	2.333797	1.387466	1.667550	1.083027	1.734876	3.930764	3.825123	2.187528	1.700309	2.850614	-0.193261	-0.512321	1.265336	2.029914	-0.293988	0.136371	2.243798	0.594780	0.582911	-0.070317	-0.166992	-0.140762	-0.125327	-0.071982	2.287212	-0.032851	-0.004647	-0.060071	2.145245	0.362300	-0.317249	0.149315	-0.199097	-0.620176	-0.387028	-0.382813	1.676715	1.261925	1.841210	-0.574705	-0.4142	1.525608	-0.527764	0.429780	2.983022	2.305652	2.274642	-0.16265	-0.145095	3.814037	-0.245172	-0.20739	-0.321053	0.254075	-1.073424	0.689566	0.884333	-1.035398	-0.892022	-0.935056	-0.613292	-0.750337	-0.387587	1.855094	-1.249929	-0.247168	0.239986	-0.706976	-0.414094	-0.631501	-0.690032	-0.425755	-0.413212	-0.254132	0.174840	1.694621	-0.092131	0.484039	2.815951	0.304963	1.068416	1.761101	-0.793394	-0.575671	-0.943666	-0.832521	0.639688	2.115412	2.286768	2.751970	4.251106	0.953948	-0.531949	-0.380601	-0.959714	2.267993	2.278894	0.610094	0.203836	0.117236	-0.526057	-0.380188	0.374022	-0.539377	1.081064	-0.211857	-0.830183	-0.42621	0.179051	-0.167324	0.068521	-0.243487	0.619329	2.633825	0.607491	0.648777	0.084270	-0.403902	-0.083607	-0.220280	0.005958	0.262357	-0.673076	-0.172332	-0.071982	-0.071982	1.199251	1.231942	-0.091641	-0.097109	-0.095811	2.335366	2.160111	-0.495192	2.447379	1.257413	1.331639	1.230050	-0.582571	2.699092	2.633064	-0.565553	1.674267	0.962012	-0.254515	3.173121	2.929711	1.721310	1.196640	2.713877	-0.355752	-0.493226	0.925423	2.254572	-0.525642	-0.257026	1.801450	0.056635	0.329927	-0.210382	-0.12408	-0.112669	-0.109024	-0.071982	2.344293	-0.520419	-0.589481	-0.222146	1.958287	-0.215280	-0.386970	-0.134149	-0.393251	-1.226060	-0.893169	-0.719211	1.273529	0.217962	1.436169	-0.457762	-0.376863	1.203450	-0.513879	0.152414	2.371996	1.093539	1.716611	-0.141863	-0.144114	3.227707	-0.229293	-0.202293	-0.958293	-0.272804	-1.749708	0.250545	0.474081	-1.549222	-1.413354	-0.861007	-0.988798	-1.529141	-1.122143	-0.315527	-2.166934	-0.785823	-0.089400	-1.709654	-0.855410	-0.578561	-1.229883	-1.230591	-1.385686	-0.955624	-0.047740	2.013244	-0.767271	0.029207	3.035756	-0.047857	0.679400	2.106100	-0.839896	-0.638943	-0.896873	-0.869454	0.442525	2.196321	2.459499	2.862300	3.892746	0.560669	-0.457435	-0.509849	-1.028097	2.394148	2.403465	-0.661067	-0.024347	-0.295774	-0.503643	-0.348982	-0.130443	-0.869226	0.811847	-0.203009	-0.785421	-0.3941	-0.691850	-0.765900	-0.516583	-0.243487	0.610876	2.632469	2.695037	0.573382	2.492710	0.129889	0.069963	0.482186	-0.010219	0.050942	0.161902	0.161902	-0.399615	0.384234	0.782663	-0.805032	0.517113	-1.859649	0.383334	1.775443
24	-0.495566	0.185169	0.440371	0.359690	0.342868	0.013283	0.586377	0.004361	-0.165957	-0.766683	-0.950249	-0.363181	-0.884977	0.180261	2.188257	0.026327	-0.182162	-0.071982	-0.071982	-0.316709	-0.313672	-0.269507	0.319704	0.322352	2.100539	2.015236	1.029148	2.279414	2.052183	1.304614	1.263467	0.925933	2.219308	2.258738	0.607327	2.406977	1.889719	1.416332	6.186883	1.855189	6.441259	1.209081	2.899841	1.202742	-0.512321	2.347240	2.112556	-0.400832	-0.132490	1.263400	2.660768	1.123340	-0.196626	-0.166992	-0.140762	-0.125327	-0.071982	2.101092	1.147350	0.648110	-0.248636	2.385554	0.032124	-0.317249	-0.222058	0.277752	0.459314	2.171725	0.378329	0.907985	0.753427	1.059317	-0.574705	-0.4142	-0.007905	-0.527764	1.620883	2.983022	2.608084	3.870593	-0.16265	-0.145095	-0.426210	-0.245172	-0.20739	0.987898	0.772014	1.116847	0.827054	-0.557353	0.252963	0.161970	0.268059	0.039003	1.355733	1.860300	1.144623	0.983370	1.661763	0.674290	-0.319355	-0.774876	-0.631501	0.138006	0.994373	1.083891	-0.323021	2.363162	1.818346	0.303392	1.083184	2.363886	0.797866	0.299790	1.896739	0.483938	0.024760	1.197592	0.392192	0.639688	2.359779	2.340801	1.968158	1.799460	1.867603	0.515747	-0.216154	1.308524	2.067486	2.074202	0.565832	0.075446	-0.243775	-0.526057	-0.380188	0.611924	-0.168973	0.169210	-0.211857	0.558226	-0.42621	1.625860	0.572827	1.004654	-0.291406	-0.032141	0.448262	-0.038703	-0.374238	-0.875736	-0.696187	-0.449659	-0.677716	-0.000878	1.392742	-0.395484	-0.172332	-0.071982	-0.071982	-0.457175	-0.455370	-0.490026	0.290022	0.291697	2.678629	2.801950	-0.420068	3.078680	2.754418	1.227566	1.195319	-0.472352	2.843842	3.043083	-0.491209	3.097349	2.615478	-0.166932	5.548517	1.521606	5.530884	0.958415	3.190556	0.939211	-0.493226	2.484415	2.903708	-0.547153	-0.400617	1.104666	3.350904	1.171142	-0.270997	-0.12408	-0.112669	-0.109024	-0.071982	2.546188	0.891171	0.534572	-0.346659	2.559205	-0.371404	-0.369092	-0.377896	0.207941	0.294628	2.322669	0.117458	0.742834	0.081417	0.905742	-0.457762	-0.376863	-0.083699	-0.513879	1.144427	2.665276	1.448982	3.382218	-0.141863	-0.144114	-0.405214	-0.229293	-0.202293	0.838880	0.552407	0.998233	0.599738	-0.604097	-0.003443	-0.143667	-0.401580	-0.249472	1.260182	1.940253	-0.296634	0.823276	1.541857	0.369143	-0.961061	-1.101155	-0.578561	-0.180279	1.101763	1.228410	-0.844685	1.908431	2.842767	0.164281	1.659001	2.947540	0.449963	0.106020	2.945811	0.266239	-0.125680	0.246771	0.175489	0.516235	3.009459	3.006996	2.309434	1.742331	1.582221	0.270371	-0.326726	0.936218	2.591038	2.590755	-0.525650	-0.060115	-0.508595	-0.503643	-0.348982	0.392002	-0.368204	0.101897	-0.203009	0.296399	-0.3941	2.408258	0.397488	0.817481	-0.291406	0.342868	2.084413	1.669986	-1.744037	2.512396	2.905859	3.489477	0.203559	-0.645403	2.585478	2.149326	2.149326	0.456216	1.484795	2.140168	0.738643	1.614134	-0.200901	1.946885	2.048424

In [314]:

#Combine both the player info dataframe and Z-Score data frame together
#Values used to standarise z-scores to allow ratings to be on a 100 scale

newdf = pd.concat([df1,df2 * 20 + 90], axis = 1)

In [315]:

newdf.head()

Out[315]:

	Player	Squad	Main Position	Comp	Age	Age	Born	MP	Starts	Min	npGoals	npxG+xA	Goals	Shots	SoT	SoT%	Sh/90	SoT/90	G/Sh	G/SoT	AvgShotDistance	FKShots	PK	PKsAtt	xG	npxG	npxG/Sh	G-xG	npG-xG	PassesCompleted	PassesAttempted	TotCmp%	TotalPassDist	ProgPassDist	ShortPassCmp	ShortPassAtt	ShortPassCmp%	MedPassCmp	MedPassAtt	MedPassCmp%	LongPassCmp	LongPassAtt	LongPassCmp%	Assists	xA	A-xA	KeyPasses	Final1/3Cmp	PenAreaCmp	CrsPenAreaCmp	ProgPasses	LivePass	DeadPass	FKPasses	ThruBalls	PassUnderPress	Switches	Crs	CK	InSwingCK	OutSwingCK	StrCK	Ground	Low	High	Left	Right	Head	ThrowIn	Other	PassesToOff	PassesOOB	PassesInt	PassesBlocked	SCA	SCA90	SCAPassLive	SCAPassDead	SCADrib	SCASh	SCAFld	SCADef	GCA	GCA90	GCAPassLive	GCAPassDead	GCADrib	GCASh	GCAFld	GCADef	DrbTkl	TklWinPoss	Def3rdPress	Mid3rdPress	Att3rdPress	DrbTkl.1	DrpPastAtt	DrbTkl%	DrbPast	Press	PressSucc	PressSucc%	Def3rdPress.1	Mid3rdPress.1	Att3rdPress.1	Blocks	ShBlocks	ShSvBlocks	PassBlocks	Int	Tkl+Int	Clr	Err	Touches	DefPenTouch	Def3rdTouch	Mid3rdTouch	Att3rdTouch	AttPenTouch	LiveTouch	SuccDrb	AttDrb	DrbSucc%	PlDrbPast	Megs	Carries	TotCarryDist	PrgCarryDist	ProgCarries	CarriesToFinal3rd	CarriesToPenArea	CarryMistakes	Disposesed	PassTarget	ReceivedPass	Receive%	ProgPassesRec	Yellows	Reds	Yellow2	Fls	Fld	Off	PKwon	PKcon	OG	Recov	AerialWins	AerialLoss	AerialWin%	npGoalsPer90	npxG+xAPer90	GoalsPer90	ShotsPer90	SoTPer90	SoT%Per90	Sh/90Per90	SoT/90Per90	G/ShPer90	G/SoTPer90	AvgShotDistancePer90	FKShotsPer90	PKPer90	PKsAttPer90	xGPer90	npxGPer90	npxG/ShPer90	G-xGPer90	npG-xGPer90	PassesCompletedPer90	PassesAttemptedPer90	TotCmp%Per90	TotalPassDistPer90	ProgPassDistPer90	ShortPassCmpPer90	ShortPassAttPer90	ShortPassCmp%Per90	MedPassCmpPer90	MedPassAttPer90	MedPassCmp%Per90	LongPassCmpPer90	LongPassAttPer90	LongPassCmp%Per90	AssistsPer90	xAPer90	A-xAPer90	KeyPassesPer90	Final1/3CmpPer90	PenAreaCmpPer90	CrsPenAreaCmpPer90	ProgPassesPer90	LivePassPer90	DeadPassPer90	FKPassesPer90	ThruBallsPer90	PassUnderPressPer90	SwitchesPer90	CrsPer90	CKPer90	InSwingCKPer90	OutSwingCKPer90	StrCKPer90	GroundPer90	LowPer90	HighPer90	LeftPer90	RightPer90	HeadPer90	ThrowInPer90	OtherPer90	PassesToOffPer90	PassesOOBPer90	PassesIntPer90	PassesBlockedPer90	SCAPer90	SCA90Per90	GCAPassLivePer90	GCAPassDeadPer90	GCADribPer90	GCAShPer90	GCAFldPer90	GCADefPer90	GCAPer90	GCA90Per90	GCAPassLive.1Per90	GCAPassDead.1Per90	GCADrib.1Per90	GCASh.1Per90	GCAFld.1Per90	GCADef.1Per90	DrbTklPer90	TklWinPossPer90	Def3rdPressPer90	Mid3rdPressPer90	Att3rdPressPer90	DrbTkl.1Per90	DrpPastAttPer90	DrbTkl%Per90	DrbPastPer90	PressPer90	PressSuccPer90	PressSucc%Per90	Def3rdPress.1Per90	Mid3rdPress.1Per90	Att3rdPress.1Per90	BlocksPer90	ShBlocksPer90	ShSvBlocksPer90	PassBlocksPer90	IntPer90	Tkl+IntPer90	ClrPer90	ErrPer90	TouchesPer90	DefPenTouchPer90	Def3rdTouchPer90	Mid3rdTouchPer90	Att3rdTouchPer90	AttPenTouchPer90	LiveTouchPer90	SuccDrbPer90	AttDrbPer90	DrbSucc%Per90	PlDrbPastPer90	MegsPer90	CarriesPer90	TotCarryDistPer90	PrgCarryDistPer90	ProgCarriesPer90	CarriesToFinal3rdPer90	CarriesToPenAreaPer90	CarryMistakesPer90	DisposesedPer90	PassTargetPer90	ReceivedPassPer90	Receive%Per90	ProgPassesRecPer90	YellowsPer90	RedsPer90	Yellow2Per90	FlsPer90	FldPer90	OffPer90	PKwonPer90	PKconPer90	OGPer90	RecovPer90	AerialWinsPer90	AerialLossPer90	AerialWin%Per90	90sPer90	AvgTeamPoss	OppTouches	TeamMins	TeamTouches90	pAdjTkl+IntPer90	pAdjPressSuccPer90	pAdjClrPer90	pAdjShBlocksPer90	pAdjIntPer90	pAdjDrbTklPer90	pAdjTklWinPossPer90	pAdjDrbPastPer90	pAdjAerialWinsPer90	pAdjAerialLossPer90	pAdjDrpPastAttPer90	TouchCentrality	Tkl+IntOppTouch	pAdjTouchesPer90	pAdjCarriesPer90
0	William Saliba	Marseille	Centre-Back	fr Ligue 1	20	61.237725	121.336333	121.780695	123.892215	125.734874	73.086911	107.652387	73.165279	103.551974	89.071813	81.283034	85.030159	79.340360	74.230898	72.533081	81.526629	86.356753	88.560368	88.560368	101.256437	101.775982	93.251904	54.134192	54.091791	165.082176	159.998601	121.212610	155.766667	147.628876	169.121724	167.765049	114.137988	167.921913	165.770042	115.696326	126.058761	114.695617	122.960012	78.370521	103.464594	65.690882	94.532470	147.996827	130.009150	98.775643	150.395497	160.964328	102.924882	130.367993	115.267999	150.101988	103.459657	91.119858	86.660166	87.184756	87.493464	88.560368	171.479112	109.013003	83.275887	79.486735	174.438342	84.038965	87.699686	107.841185	86.018069	97.223580	125.438403	110.614723	103.766953	84.728632	108.580031	78.505902	81.715994	105.177036	79.444722	74.773523	109.932321	93.772602	103.573812	86.747	87.098095	123.878264	85.096561	85.852193	117.393509	120.978442	127.500360	95.542041	98.075420	88.031839	93.239394	77.266331	98.607603	104.580969	122.148251	138.102741	106.586995	101.873418	93.062514	102.993981	91.338985	77.369974	107.480803	119.965774	121.477043	90.887745	115.380020	154.790291	111.461155	134.381253	167.155896	118.134920	119.908613	155.680371	153.965367	142.532602	98.891514	149.894171	166.434536	166.427467	163.446227	168.655740	176.944973	113.139654	110.791911	105.410538	142.633250	165.026322	164.713762	99.546130	99.212307	92.344711	79.478864	82.396244	76.862232	84.768520	93.384200	85.762864	73.396349	81.475792	117.484826	92.292761	93.866777	89.922193	73.863828	89.498419	73.858010	85.376268	79.982417	77.661255	77.120396	77.806959	79.072788	75.969988	70.581753	86.55337	88.560368	88.560368	86.903466	87.052317	77.123303	71.134928	71.144356	138.155880	135.571133	70.809433	131.320863	122.742185	133.029621	132.079507	69.536428	141.915342	141.193216	69.793491	102.770063	89.276737	74.516372	78.002641	90.706807	75.242806	82.263507	119.989435	106.080756	90.697257	119.289870	136.371241	86.644165	105.434999	100.468473	118.374904	86.297674	84.770125	87.518405	87.746617	87.819515	88.560368	142.752718	83.668912	58.518139	75.497791	142.375277	57.638007	83.491442	90.265952	77.195370	74.903623	99.339141	88.902003	84.915910	75.286313	89.139109	80.844765	82.462738	93.657659	79.722415	76.130904	94.709254	83.826180	91.033739	87.162749	87.117718	108.828674	85.414136	85.954131	88.413200	92.258366	97.879989	76.820730	86.338053	69.161648	72.185054	68.001136	78.804104	75.303155	90.692995	75.849699	76.495671	77.730679	81.128121	69.755897	71.978574	78.428787	81.939778	92.281266	90.417511	64.167677	97.404728	133.541803	86.311248	111.833425	138.025442	94.956428	96.115697	134.543353	118.168635	110.349777	77.559252	115.089875	132.390784	139.054057	137.687194	140.300314	139.783765	93.852364	95.751115	89.201599	109.792405	137.752886	137.567984	68.493260	88.451827	75.673787	79.927148	83.020362	56.321867	71.918488	86.675648	85.939824	74.291575	82.117994	82.335462	68.075945	68.904940	89.922193	125.734874	123.393370	126.446832	101.467644	122.433965	111.053709	107.100705	75.453630	79.903015	110.478036	103.794374	103.794374	87.380606	79.658700	80.371370	81.388812	123.257864	75.976294	119.985291	130.090871
14	Presnel Kimpembe	Paris S-G	Centre-Back	fr Ligue 1	25	108.365101	66.070437	104.550733	106.902319	107.100605	90.265651	80.003089	90.087227	78.245294	74.666349	76.022121	69.738341	70.540487	101.354952	133.765141	76.126682	86.356753	88.560368	88.560368	86.178770	86.305053	101.893951	93.908207	93.955554	136.949234	129.558642	131.510083	124.705610	123.436194	159.480006	154.852314	127.718020	131.276886	128.097816	120.623519	98.147981	86.740956	136.087890	78.370521	75.885531	85.541623	79.795612	134.705465	90.123358	98.775643	113.552284	130.137029	96.941589	111.009983	76.052065	100.083323	82.743206	81.015092	86.660166	87.184756	87.493464	88.560368	140.561434	99.964793	65.247361	160.080752	72.667388	84.038965	89.497313	78.131401	66.944129	67.782939	72.664117	75.819671	97.177836	87.553619	100.761102	122.228549	81.715994	74.506776	79.444722	74.773523	109.932321	99.821237	119.533324	86.747	87.098095	81.475792	85.096561	85.852193	89.032906	84.722719	87.064585	92.792281	88.464184	85.689365	82.699479	99.211147	80.343346	84.239421	74.380666	48.720812	81.173583	86.420169	94.799729	74.568398	88.933771	77.369974	68.839028	96.144282	93.168189	87.213664	93.496803	124.995910	108.895602	103.737483	142.427071	94.069662	80.623293	125.737107	93.292093	94.498078	89.215888	94.782064	81.580173	133.691444	129.566872	129.118428	125.027763	94.866549	100.314948	88.965850	82.146909	135.446102	135.795637	103.972395	99.212307	99.564931	79.478864	82.396244	97.480434	110.696805	75.147122	85.762864	128.932698	81.475792	90.058365	87.358419	73.895937	112.683870	87.161894	73.533993	87.048412	70.081367	71.470899	77.350075	73.782021	75.116296	92.182164	111.920077	72.288652	86.55337	88.560368	88.560368	80.112210	80.134430	86.215390	93.499014	93.530273	132.758589	125.863362	78.585992	119.330576	117.597395	147.528860	143.739418	76.841156	126.379798	123.419703	76.627433	87.151313	69.616293	84.758607	78.002641	74.693585	86.452524	75.340798	125.309102	85.042404	93.419702	102.217743	126.342219	88.336879	101.457049	75.490282	83.701622	74.158104	79.985040	87.518405	87.746617	87.819515	88.560368	135.388553	86.568634	45.535768	145.306300	64.575976	66.694882	86.162055	73.267527	63.036751	52.589626	60.076000	68.690857	87.489697	79.638675	91.208663	106.888443	82.462738	73.711348	79.722415	76.130904	101.196907	89.748972	108.423772	87.162749	87.117718	81.895725	85.414136	85.954131	73.765182	70.710502	72.735254	81.934286	83.679868	73.923916	70.365446	78.369138	70.996858	66.895314	55.907943	68.385489	62.789172	73.109528	86.616121	51.076437	77.307713	78.428787	56.410814	80.977934	73.950401	70.500793	87.875448	122.648083	100.946714	90.741313	137.535810	86.041580	72.608703	123.663690	86.828387	87.739907	78.815455	87.681909	81.785407	128.319798	124.343050	122.203616	113.897829	87.193993	93.344934	83.486848	77.355953	130.470803	130.905631	74.693707	91.910056	87.952433	79.927148	83.020362	83.772185	101.807433	75.153769	85.939824	111.432937	82.117994	64.204492	72.433158	58.376319	112.683870	107.100605	127.540818	141.338121	101.467644	137.296512	95.439628	69.171157	87.162309	89.176896	100.320134	88.441220	88.441220	78.388923	86.455114	68.982414	80.561337	92.395181	60.813106	101.273964	126.117742
18	Jean-Clair Todibo	Nice	Centre-Back	fr Ligue 1	21	70.663201	102.914367	121.780695	121.465087	122.226916	90.265651	123.451986	90.087227	114.799387	110.680008	94.376863	95.734432	95.180131	83.918060	82.942532	76.126682	86.356753	88.560368	88.560368	123.872936	124.982374	106.214975	56.620068	56.583276	134.237137	135.303438	101.614193	134.618157	130.653835	120.913136	121.786057	98.684848	142.233379	141.608348	109.126736	120.643236	126.037222	88.016687	78.370521	103.464594	65.690882	133.830757	140.612737	106.077675	89.264611	128.757420	136.325552	93.949943	123.915323	134.875966	122.555477	103.459657	86.067475	86.660166	87.184756	87.493464	88.560368	135.875610	100.751594	118.918491	79.812650	146.121906	123.660062	81.407992	122.696077	124.165950	132.552349	119.041520	106.265342	123.534306	101.113559	124.217887	100.367226	81.715994	135.847296	79.444722	74.773523	123.175028	105.869872	103.573812	86.747	87.098095	166.280736	85.096561	85.852193	130.483018	129.610756	139.294128	112.040596	88.464184	139.566261	139.351523	93.243697	132.526937	121.634994	128.891910	105.558552	128.149890	115.054130	89.588083	110.746413	103.365055	77.369974	109.320887	119.049563	127.465454	110.635934	71.613585	134.860492	111.033563	122.335942	143.624593	90.010462	107.952211	135.660964	96.485423	98.500955	87.953850	97.843848	81.580173	139.915899	141.233360	132.408672	144.256359	105.018274	79.361022	92.254787	93.488098	135.791061	136.405357	106.628154	94.076711	99.564931	79.478864	82.396244	91.136372	79.212458	75.147122	85.762864	101.164524	81.475792	121.007491	101.456539	113.837616	80.817522	84.860881	102.474324	84.766028	95.584489	95.814874	82.403200	81.066281	83.970503	82.944579	81.024005	69.337943	86.55337	88.560368	88.560368	105.289214	105.780888	83.410020	71.737717	71.747734	111.195323	112.499641	70.150548	113.176404	108.600698	96.677379	96.570796	69.632167	120.562803	120.216934	70.365942	100.178520	104.708959	69.361929	78.002641	91.469267	74.709062	108.881650	116.743553	92.462396	85.628283	104.384819	113.899710	81.826530	102.325215	114.461071	94.529153	87.710028	82.244032	87.518405	87.746617	87.819515	88.560368	112.937783	79.215846	94.670215	75.905850	122.780804	95.594246	79.983393	101.588703	107.217095	108.785844	96.247730	87.282003	100.932083	81.944464	102.031136	91.613387	82.462738	115.204797	79.722415	76.130904	104.445564	89.624635	91.820789	87.162749	87.117718	137.923177	85.414136	85.954131	102.273745	101.777822	110.634936	90.233759	81.291637	112.033912	109.997159	72.126379	103.879619	92.526115	99.530787	72.551574	98.459315	89.979379	79.767666	79.948697	82.013193	78.428787	85.206318	94.311759	100.558204	87.041282	71.727506	112.956742	88.656646	99.660110	119.211439	80.140517	89.089351	114.237262	85.531405	86.919777	74.502132	86.076263	81.785407	116.881667	119.733556	110.913438	118.220647	89.705190	80.851303	82.622531	81.836736	112.843849	113.729422	69.634026	86.199273	81.656304	79.927148	83.020362	69.619215	68.212655	75.153769	85.939824	89.648902	82.117994	90.999420	78.132306	87.422628	80.817522	122.226916	92.583756	98.831648	101.467644	94.872084	99.382557	98.411316	87.863139	82.203275	93.889182	101.481713	101.481713	104.488806	79.252084	87.862668	109.910117	125.238884	95.081718	125.284548	118.060967
20	Rúben Dias	Manchester City	Centre-Back	eng Premier League	24	98.939626	84.492402	101.679072	102.048063	102.217528	107.444390	151.101284	107.009174	109.175680	96.274545	85.257947	102.615750	91.660182	95.542655	103.149111	82.876616	86.356753	88.560368	88.560368	118.847047	119.825398	101.893951	86.450579	86.481098	133.994263	128.887172	123.205669	133.857379	116.643815	123.577295	121.544697	116.947650	139.346195	136.675932	117.749323	123.350998	111.660539	124.697525	168.615281	166.502450	133.750566	124.006185	147.012282	86.134779	79.753578	115.306723	130.598285	84.120247	92.727417	134.875966	101.895594	101.658227	88.593667	86.660166	87.184756	87.493464	88.560368	135.744232	89.342981	89.907069	88.798580	132.904899	97.245998	83.655025	92.986293	86.018069	77.596486	82.259442	82.343743	123.534306	115.238496	126.824197	78.505902	81.715994	120.512166	79.444722	98.595592	149.660440	136.113045	135.492836	86.747	87.098095	166.280736	85.096561	85.852193	83.578944	95.081497	68.531521	103.791318	107.686655	69.292049	72.159564	71.298880	77.734166	74.993263	82.248268	127.101889	65.001411	85.056647	94.799729	75.860470	81.718129	77.369974	76.199366	81.484903	81.735768	84.917363	93.496803	123.892414	88.157387	99.680773	146.319017	96.099262	111.368326	125.222028	74.132112	78.486570	71.126676	73.349578	102.793764	132.308232	135.735360	145.039402	175.022114	109.078964	79.361022	82.387974	70.805720	135.359863	135.577880	102.201889	94.076711	92.344711	79.478864	82.396244	97.480434	79.212458	111.621278	85.762864	73.396349	81.475792	93.581030	86.653513	91.370422	85.130261	102.386575	142.676493	102.149830	102.975537	91.685408	81.921963	88.327856	85.594407	90.119156	95.247138	76.538473	86.55337	88.560368	88.560368	113.985029	114.638846	88.167173	88.057830	88.083777	136.707322	133.202226	80.096155	138.947580	115.148265	116.632772	114.601004	78.348589	143.981835	142.661275	78.688934	123.485346	109.240234	84.909693	153.462420	148.594221	124.426200	113.932792	144.277542	82.884958	80.135482	108.508457	135.091448	79.487155	84.859485	126.029003	91.132709	96.598547	85.792352	87.518405	87.746617	87.819515	88.560368	136.885855	79.591628	78.210380	85.557084	129.165734	85.694395	82.260606	87.317017	82.134971	65.478796	72.136613	75.615780	115.470574	94.359231	118.723378	80.844765	82.462738	114.068996	79.722415	93.048288	137.439916	111.870785	124.332217	87.162749	87.117718	154.554139	85.414136	85.954131	70.834135	84.543927	55.005846	95.010896	99.481625	59.015557	61.732930	72.779853	70.224042	59.417171	67.557148	83.689453	46.661318	74.283539	88.212007	55.806917	72.891810	78.428787	65.402346	65.388186	62.286285	70.887517	89.045199	130.264870	74.654570	90.584136	150.715122	89.042851	103.588006	132.122010	73.202080	77.221133	72.062545	72.610926	98.850501	133.926426	139.189989	147.246007	167.854917	101.213376	80.851303	79.803030	69.438063	137.882958	138.069295	76.778658	89.513063	84.084514	79.927148	83.020362	87.391143	72.615471	106.236940	85.939824	74.291575	82.117994	76.163001	74.682005	79.668349	85.130261	102.217528	142.649378	143.900749	101.467644	139.854194	92.597784	91.399259	99.643722	89.795626	91.018836	93.238040	93.238040	82.007698	97.684681	105.653252	73.899360	100.342263	52.807012	97.666687	125.508865
24	Dayot Upamecano	Bayern Munich	Centre-Back	de Bundesliga	22	80.088676	93.703385	98.807412	97.193807	96.857369	90.265651	101.727537	90.087227	86.680854	74.666349	70.995026	82.736386	72.300462	93.605222	133.765141	90.526541	86.356753	88.560368	88.560368	83.665826	83.726565	84.609857	96.394083	96.447039	132.010789	130.304719	110.582960	135.588289	131.043658	116.092277	115.269349	108.518665	134.386161	135.174761	102.146546	138.139546	127.794372	118.326643	213.737662	127.103790	218.825171	114.181613	147.996827	114.054834	79.753578	136.944800	132.251121	81.983357	87.350192	115.267999	143.215360	112.466810	86.067475	86.660166	87.184756	87.493464	88.560368	132.021848	112.947007	102.962209	85.027283	137.711083	90.642481	83.655025	85.558847	95.555039	99.186289	133.434507	97.566579	108.159698	105.068541	111.186340	78.505902	81.715994	89.841906	79.444722	122.417660	149.660440	142.161680	167.411861	86.747	87.098095	81.475792	85.096561	85.852193	109.757962	105.440275	112.336945	106.541078	78.852948	95.059260	93.239394	95.361179	90.780064	117.114650	127.205995	112.892454	109.667409	123.235262	103.485807	83.612902	74.502487	77.369974	92.760127	109.887451	111.677824	83.539582	137.263238	126.366919	96.067840	111.663672	137.277727	105.957319	95.995810	127.934778	99.678753	90.495201	113.951835	97.843848	102.793764	137.195582	136.816029	129.363157	125.989193	127.352069	100.314948	85.676912	116.170476	131.349716	131.484049	101.316636	91.508912	85.124491	79.478864	82.396244	102.238481	86.620540	93.384200	85.762864	101.164524	81.475792	122.517204	101.456539	110.093084	84.171874	89.357188	98.965247	89.225932	82.515250	72.485285	76.076256	81.006822	76.445685	89.982445	117.854850	82.090319	86.55337	88.560368	88.560368	80.856503	80.892602	80.199481	95.800434	95.833939	143.572571	146.039004	81.598632	151.573598	145.088369	114.551312	113.906374	80.552952	146.876843	150.861669	80.175825	151.946979	142.309553	86.661355	200.970341	120.432129	200.617688	109.168310	153.811128	108.784224	80.135482	139.688306	148.074169	79.056936	81.987660	112.093330	157.018077	113.422850	84.580067	87.518405	87.746617	87.819515	88.560368	140.923759	107.823429	100.691437	83.066830	141.184108	82.571915	82.618157	82.442081	94.158816	95.892564	136.453386	92.349156	104.856689	91.628344	108.114847	80.844765	82.462738	88.326012	79.722415	112.888532	143.305511	118.979643	157.644367	87.162749	87.117718	81.895725	85.414136	85.954131	106.777608	101.048139	109.964662	101.994759	77.918062	89.931148	87.126665	81.968405	85.010559	115.203641	128.805052	84.067327	106.465519	120.837141	97.382858	70.778783	67.976893	78.428787	86.394420	112.035259	114.568200	73.106308	128.168617	146.855349	93.285622	123.180016	148.950806	98.999267	92.120390	148.916227	95.324783	87.486393	94.935428	93.509773	100.324690	150.189171	150.139926	136.188674	124.846629	121.644415	95.407429	83.465485	108.724368	141.820751	141.815102	79.487000	88.797701	79.828095	79.927148	83.020362	97.840034	82.635924	92.037934	85.939824	95.927972	82.117994	138.165168	97.949758	106.349614	84.171874	96.857369	131.688266	123.399727	55.119251	140.247914	148.117187	159.789539	94.071184	77.091945	141.709555	132.986523	132.986523	99.124330	119.695897	132.803370	104.772867	122.282686	85.981980	128.937705	130.968472

In [316]:

#List of all metrics, to create attributes and weightings
newdf.columns.values.tolist()

Out[316]:

['Player',
 'Squad',
 'Main Position',
 'Comp',
 'Age',
 'Age',
 'Born',
 'MP',
 'Starts',
 'Min',
 'npGoals',
 'npxG+xA',
 'Goals',
 'Shots',
 'SoT',
 'SoT%',
 'Sh/90',
 'SoT/90',
 'G/Sh',
 'G/SoT',
 'AvgShotDistance',
 'FKShots',
 'PK',
 'PKsAtt',
 'xG',
 'npxG',
 'npxG/Sh',
 'G-xG',
 'npG-xG',
 'PassesCompleted',
 'PassesAttempted',
 'TotCmp%',
 'TotalPassDist',
 'ProgPassDist',
 'ShortPassCmp',
 'ShortPassAtt',
 'ShortPassCmp%',
 'MedPassCmp',
 'MedPassAtt',
 'MedPassCmp%',
 'LongPassCmp',
 'LongPassAtt',
 'LongPassCmp%',
 'Assists',
 'xA',
 'A-xA',
 'KeyPasses',
 'Final1/3Cmp',
 'PenAreaCmp',
 'CrsPenAreaCmp',
 'ProgPasses',
 'LivePass',
 'DeadPass',
 'FKPasses',
 'ThruBalls',
 'PassUnderPress',
 'Switches',
 'Crs',
 'CK',
 'InSwingCK',
 'OutSwingCK',
 'StrCK',
 'Ground',
 'Low',
 'High',
 'Left',
 'Right',
 'Head',
 'ThrowIn',
 'Other',
 'PassesToOff',
 'PassesOOB',
 'PassesInt',
 'PassesBlocked',
 'SCA',
 'SCA90',
 'SCAPassLive',
 'SCAPassDead',
 'SCADrib',
 'SCASh',
 'SCAFld',
 'SCADef',
 'GCA',
 'GCA90',
 'GCAPassLive',
 'GCAPassDead',
 'GCADrib',
 'GCASh',
 'GCAFld',
 'GCADef',
 'DrbTkl',
 'TklWinPoss',
 'Def3rdPress',
 'Mid3rdPress',
 'Att3rdPress',
 'DrbTkl.1',
 'DrpPastAtt',
 'DrbTkl%',
 'DrbPast',
 'Press',
 'PressSucc',
 'PressSucc%',
 'Def3rdPress.1',
 'Mid3rdPress.1',
 'Att3rdPress.1',
 'Blocks',
 'ShBlocks',
 'ShSvBlocks',
 'PassBlocks',
 'Int',
 'Tkl+Int',
 'Clr',
 'Err',
 'Touches',
 'DefPenTouch',
 'Def3rdTouch',
 'Mid3rdTouch',
 'Att3rdTouch',
 'AttPenTouch',
 'LiveTouch',
 'SuccDrb',
 'AttDrb',
 'DrbSucc%',
 'PlDrbPast',
 'Megs',
 'Carries',
 'TotCarryDist',
 'PrgCarryDist',
 'ProgCarries',
 'CarriesToFinal3rd',
 'CarriesToPenArea',
 'CarryMistakes',
 'Disposesed',
 'PassTarget',
 'ReceivedPass',
 'Receive%',
 'ProgPassesRec',
 'Yellows',
 'Reds',
 'Yellow2',
 'Fls',
 'Fld',
 'Off',
 'PKwon',
 'PKcon',
 'OG',
 'Recov',
 'AerialWins',
 'AerialLoss',
 'AerialWin%',
 'npGoalsPer90',
 'npxG+xAPer90',
 'GoalsPer90',
 'ShotsPer90',
 'SoTPer90',
 'SoT%Per90',
 'Sh/90Per90',
 'SoT/90Per90',
 'G/ShPer90',
 'G/SoTPer90',
 'AvgShotDistancePer90',
 'FKShotsPer90',
 'PKPer90',
 'PKsAttPer90',
 'xGPer90',
 'npxGPer90',
 'npxG/ShPer90',
 'G-xGPer90',
 'npG-xGPer90',
 'PassesCompletedPer90',
 'PassesAttemptedPer90',
 'TotCmp%Per90',
 'TotalPassDistPer90',
 'ProgPassDistPer90',
 'ShortPassCmpPer90',
 'ShortPassAttPer90',
 'ShortPassCmp%Per90',
 'MedPassCmpPer90',
 'MedPassAttPer90',
 'MedPassCmp%Per90',
 'LongPassCmpPer90',
 'LongPassAttPer90',
 'LongPassCmp%Per90',
 'AssistsPer90',
 'xAPer90',
 'A-xAPer90',
 'KeyPassesPer90',
 'Final1/3CmpPer90',
 'PenAreaCmpPer90',
 'CrsPenAreaCmpPer90',
 'ProgPassesPer90',
 'LivePassPer90',
 'DeadPassPer90',
 'FKPassesPer90',
 'ThruBallsPer90',
 'PassUnderPressPer90',
 'SwitchesPer90',
 'CrsPer90',
 'CKPer90',
 'InSwingCKPer90',
 'OutSwingCKPer90',
 'StrCKPer90',
 'GroundPer90',
 'LowPer90',
 'HighPer90',
 'LeftPer90',
 'RightPer90',
 'HeadPer90',
 'ThrowInPer90',
 'OtherPer90',
 'PassesToOffPer90',
 'PassesOOBPer90',
 'PassesIntPer90',
 'PassesBlockedPer90',
 'SCAPer90',
 'SCA90Per90',
 'GCAPassLivePer90',
 'GCAPassDeadPer90',
 'GCADribPer90',
 'GCAShPer90',
 'GCAFldPer90',
 'GCADefPer90',
 'GCAPer90',
 'GCA90Per90',
 'GCAPassLive.1Per90',
 'GCAPassDead.1Per90',
 'GCADrib.1Per90',
 'GCASh.1Per90',
 'GCAFld.1Per90',
 'GCADef.1Per90',
 'DrbTklPer90',
 'TklWinPossPer90',
 'Def3rdPressPer90',
 'Mid3rdPressPer90',
 'Att3rdPressPer90',
 'DrbTkl.1Per90',
 'DrpPastAttPer90',
 'DrbTkl%Per90',
 'DrbPastPer90',
 'PressPer90',
 'PressSuccPer90',
 'PressSucc%Per90',
 'Def3rdPress.1Per90',
 'Mid3rdPress.1Per90',
 'Att3rdPress.1Per90',
 'BlocksPer90',
 'ShBlocksPer90',
 'ShSvBlocksPer90',
 'PassBlocksPer90',
 'IntPer90',
 'Tkl+IntPer90',
 'ClrPer90',
 'ErrPer90',
 'TouchesPer90',
 'DefPenTouchPer90',
 'Def3rdTouchPer90',
 'Mid3rdTouchPer90',
 'Att3rdTouchPer90',
 'AttPenTouchPer90',
 'LiveTouchPer90',
 'SuccDrbPer90',
 'AttDrbPer90',
 'DrbSucc%Per90',
 'PlDrbPastPer90',
 'MegsPer90',
 'CarriesPer90',
 'TotCarryDistPer90',
 'PrgCarryDistPer90',
 'ProgCarriesPer90',
 'CarriesToFinal3rdPer90',
 'CarriesToPenAreaPer90',
 'CarryMistakesPer90',
 'DisposesedPer90',
 'PassTargetPer90',
 'ReceivedPassPer90',
 'Receive%Per90',
 'ProgPassesRecPer90',
 'YellowsPer90',
 'RedsPer90',
 'Yellow2Per90',
 'FlsPer90',
 'FldPer90',
 'OffPer90',
 'PKwonPer90',
 'PKconPer90',
 'OGPer90',
 'RecovPer90',
 'AerialWinsPer90',
 'AerialLossPer90',
 'AerialWin%Per90',
 '90sPer90',
 'AvgTeamPoss',
 'OppTouches',
 'TeamMins',
 'TeamTouches90',
 'pAdjTkl+IntPer90',
 'pAdjPressSuccPer90',
 'pAdjClrPer90',
 'pAdjShBlocksPer90',
 'pAdjIntPer90',
 'pAdjDrbTklPer90',
 'pAdjTklWinPossPer90',
 'pAdjDrbPastPer90',
 'pAdjAerialWinsPer90',
 'pAdjAerialLossPer90',
 'pAdjDrpPastAttPer90',
 'TouchCentrality',
 'Tkl+IntOppTouch',
 'pAdjTouchesPer90',
 'pAdjCarriesPer90']

In [317]:

#Weight and Ratings for metrics

#Minutes Played
newdf['Minutes (12.5%)'] = newdf['Min']

#Defending
newdf['ClearancesPer90'] = newdf['ClrPer90'] *0.2
newdf['DribblersTackledPer90'] = newdf['DrbTkl%Per90'] *0.3
newdf['ShotBlocksPer90'] = newdf['ShBlocksPer90'] *0.3
newdf['PAdjInterceptionsPer90'] = newdf['pAdjIntPer90'] *0.2

newdf['Defending (20%)'] = newdf['AerialWinsPer90'] + newdf['DribblersTackledPer90'] + newdf['ShotBlocksPer90'] + newdf['PAdjInterceptionsPer90']


#Aerial Ability
newdf['AerialWinsPer90'] = newdf['AerialWinsPer90'] *0.35
newdf['AerialDuelSuccessPer90'] = newdf['AerialWin%Per90'] *0.65

newdf['Aerial (20%)'] = newdf['AerialWinsPer90'] + newdf['AerialDuelSuccessPer90']


#Front Foot
newdf['MiddlesThirsPressures'] = newdf['Mid3rdPressPer90'] *0.15
newdf['PressuresPer90'] = newdf['PressSuccPer90'] *0.40
newdf['PressureSuccess'] = newdf['PressSucc%Per90'] *0.45

newdf['Front Foot (5%)'] = newdf['MiddlesThirsPressures'] + newdf['PressuresPer90'] + newdf['PressureSuccess']


#Ball Carrying
newdf['ProgressiveCarriePer90'] = newdf['ProgCarriesPer90'] *0.4
newdf['CarriesToFinal3rdPer90'] = newdf['CarriesToFinal3rdPer90'] *0.2
newdf['TotalCarryDistancePer90'] = newdf['TotCarryDistPer90'] *0.2
newdf['ProgressiveCarryDistancePer90'] = newdf['PrgCarryDistPer90'] *0.2

newdf['Ball Carrying (15%)'] = newdf['ProgressiveCarriePer90'] + newdf['CarriesToFinal3rdPer90'] + newdf['TotalCarryDistancePer90'] + newdf['ProgressiveCarryDistancePer90']


#Ball Playing
newdf['ProgressivePassesPer90'] = newdf['ProgPassesPer90'] *0.55
newdf['FinalThirdCompletedPassesPer90'] = newdf['Final1/3CmpPer90'] *0.25
newdf['PenaltyAreaCompletedPassesPer90'] = newdf['PenAreaCmpPer90'] *0.2

newdf['Ball Playing (15%)'] = newdf['ProgressivePassesPer90'] + newdf['FinalThirdCompletedPassesPer90'] + newdf['PenaltyAreaCompletedPassesPer90']


#Ball Retention
newdf['ShortPassCompletion'] = newdf['ShortPassCmp%Per90'] *0.4
newdf['MediumPassCompletion'] = newdf['MedPassCmp%Per90'] *0.35
newdf['LongPassCompletion'] = newdf['LongPassCmp%Per90'] *0.15

newdf['Ball Retention (10%)'] = newdf['ShortPassCompletion'] + newdf['MediumPassCompletion'] + newdf['LongPassCompletion']


#Attacking Threat
newdf['NPxGPer90'] = newdf['npxGPer90'] *0.4
newdf['ShotsPer90'] = newdf['ShotsPer90'] *0.15
newdf['AttackingBoxTouchesPer90'] = newdf['AttPenTouchPer90'] *0.3

newdf['Attacking Threat (2.5%)'] = newdf['NPxGPer90'] + newdf['ShotsPer90'] + newdf['AttackingBoxTouchesPer90']

In [318]:

newdf.head()

Out[318]:

	Player	Squad	Main Position	Comp	Age	Age	Born	MP	Starts	Min	npGoals	npxG+xA	Goals	Shots	SoT	SoT%	Sh/90	SoT/90	G/Sh	G/SoT	AvgShotDistance	FKShots	PK	PKsAtt	xG	npxG	npxG/Sh	G-xG	npG-xG	PassesCompleted	PassesAttempted	TotCmp%	TotalPassDist	ProgPassDist	ShortPassCmp	ShortPassAtt	ShortPassCmp%	MedPassCmp	MedPassAtt	MedPassCmp%	LongPassCmp	LongPassAtt	LongPassCmp%	Assists	xA	A-xA	KeyPasses	Final1/3Cmp	PenAreaCmp	CrsPenAreaCmp	ProgPasses	LivePass	DeadPass	FKPasses	ThruBalls	PassUnderPress	Switches	Crs	CK	InSwingCK	OutSwingCK	StrCK	Ground	Low	High	Left	Right	Head	ThrowIn	Other	PassesToOff	PassesOOB	PassesInt	PassesBlocked	SCA	SCA90	SCAPassLive	SCAPassDead	SCADrib	SCASh	SCAFld	SCADef	GCA	GCA90	GCAPassLive	GCAPassDead	GCADrib	GCASh	GCAFld	GCADef	DrbTkl	TklWinPoss	Def3rdPress	Mid3rdPress	Att3rdPress	DrbTkl.1	DrpPastAtt	DrbTkl%	DrbPast	Press	PressSucc	PressSucc%	Def3rdPress.1	Mid3rdPress.1	Att3rdPress.1	Blocks	ShBlocks	ShSvBlocks	PassBlocks	Int	Tkl+Int	Clr	Err	Touches	DefPenTouch	Def3rdTouch	Mid3rdTouch	Att3rdTouch	AttPenTouch	LiveTouch	SuccDrb	AttDrb	DrbSucc%	PlDrbPast	Megs	Carries	TotCarryDist	PrgCarryDist	ProgCarries	CarriesToFinal3rd	CarriesToPenArea	CarryMistakes	Disposesed	PassTarget	ReceivedPass	Receive%	ProgPassesRec	Yellows	Reds	Yellow2	Fls	Fld	Off	PKwon	PKcon	OG	Recov	AerialWins	AerialLoss	AerialWin%	npGoalsPer90	npxG+xAPer90	GoalsPer90	ShotsPer90	SoTPer90	SoT%Per90	Sh/90Per90	SoT/90Per90	G/ShPer90	G/SoTPer90	AvgShotDistancePer90	FKShotsPer90	PKPer90	PKsAttPer90	xGPer90	npxGPer90	npxG/ShPer90	G-xGPer90	npG-xGPer90	PassesCompletedPer90	PassesAttemptedPer90	TotCmp%Per90	TotalPassDistPer90	ProgPassDistPer90	ShortPassCmpPer90	ShortPassAttPer90	ShortPassCmp%Per90	MedPassCmpPer90	MedPassAttPer90	MedPassCmp%Per90	LongPassCmpPer90	LongPassAttPer90	LongPassCmp%Per90	AssistsPer90	xAPer90	A-xAPer90	KeyPassesPer90	Final1/3CmpPer90	PenAreaCmpPer90	CrsPenAreaCmpPer90	ProgPassesPer90	LivePassPer90	DeadPassPer90	FKPassesPer90	ThruBallsPer90	PassUnderPressPer90	SwitchesPer90	CrsPer90	CKPer90	InSwingCKPer90	OutSwingCKPer90	StrCKPer90	GroundPer90	LowPer90	HighPer90	LeftPer90	RightPer90	HeadPer90	ThrowInPer90	OtherPer90	PassesToOffPer90	PassesOOBPer90	PassesIntPer90	PassesBlockedPer90	SCAPer90	SCA90Per90	GCAPassLivePer90	GCAPassDeadPer90	GCADribPer90	GCAShPer90	GCAFldPer90	GCADefPer90	GCAPer90	GCA90Per90	GCAPassLive.1Per90	GCAPassDead.1Per90	GCADrib.1Per90	GCASh.1Per90	GCAFld.1Per90	GCADef.1Per90	DrbTklPer90	TklWinPossPer90	Def3rdPressPer90	Mid3rdPressPer90	Att3rdPressPer90	DrbTkl.1Per90	DrpPastAttPer90	DrbTkl%Per90	DrbPastPer90	PressPer90	PressSuccPer90	PressSucc%Per90	Def3rdPress.1Per90	Mid3rdPress.1Per90	Att3rdPress.1Per90	BlocksPer90	ShBlocksPer90	ShSvBlocksPer90	PassBlocksPer90	IntPer90	Tkl+IntPer90	ClrPer90	ErrPer90	TouchesPer90	DefPenTouchPer90	Def3rdTouchPer90	Mid3rdTouchPer90	Att3rdTouchPer90	AttPenTouchPer90	LiveTouchPer90	SuccDrbPer90	AttDrbPer90	DrbSucc%Per90	PlDrbPastPer90	MegsPer90	CarriesPer90	TotCarryDistPer90	PrgCarryDistPer90	ProgCarriesPer90	CarriesToFinal3rdPer90	CarriesToPenAreaPer90	CarryMistakesPer90	DisposesedPer90	PassTargetPer90	ReceivedPassPer90	Receive%Per90	ProgPassesRecPer90	YellowsPer90	RedsPer90	Yellow2Per90	FlsPer90	FldPer90	OffPer90	PKwonPer90	PKconPer90	OGPer90	RecovPer90	AerialWinsPer90	AerialLossPer90	AerialWin%Per90	90sPer90	AvgTeamPoss	OppTouches	TeamMins	TeamTouches90	pAdjTkl+IntPer90	pAdjPressSuccPer90	pAdjClrPer90	pAdjShBlocksPer90	pAdjIntPer90	pAdjDrbTklPer90	pAdjTklWinPossPer90	pAdjDrbPastPer90	pAdjAerialWinsPer90	pAdjAerialLossPer90	pAdjDrpPastAttPer90	TouchCentrality	Tkl+IntOppTouch	pAdjTouchesPer90	pAdjCarriesPer90	Minutes (12.5%)	ClearancesPer90	DribblersTackledPer90	ShotBlocksPer90	PAdjInterceptionsPer90	Defending (20%)	AerialDuelSuccessPer90	Aerial (20%)	MiddlesThirsPressures	PressuresPer90	PressureSuccess	Front Foot (5%)	ProgressiveCarriePer90	TotalCarryDistancePer90	ProgressiveCarryDistancePer90	Ball Carrying (15%)	ProgressivePassesPer90	FinalThirdCompletedPassesPer90	PenaltyAreaCompletedPassesPer90	Ball Playing (15%)	ShortPassCompletion	MediumPassCompletion	LongPassCompletion	Ball Retention (10%)	NPxGPer90	AttackingBoxTouchesPer90	Attacking Threat (2.5%)
0	William Saliba	Marseille	Centre-Back	fr Ligue 1	20	61.237725	121.336333	121.780695	123.892215	125.734874	73.086911	107.652387	73.165279	103.551974	89.071813	81.283034	85.030159	79.340360	74.230898	72.533081	81.526629	86.356753	88.560368	88.560368	101.256437	101.775982	93.251904	54.134192	54.091791	165.082176	159.998601	121.212610	155.766667	147.628876	169.121724	167.765049	114.137988	167.921913	165.770042	115.696326	126.058761	114.695617	122.960012	78.370521	103.464594	65.690882	94.532470	147.996827	130.009150	98.775643	150.395497	160.964328	102.924882	130.367993	115.267999	150.101988	103.459657	91.119858	86.660166	87.184756	87.493464	88.560368	171.479112	109.013003	83.275887	79.486735	174.438342	84.038965	87.699686	107.841185	86.018069	97.223580	125.438403	110.614723	103.766953	84.728632	108.580031	78.505902	81.715994	105.177036	79.444722	74.773523	109.932321	93.772602	103.573812	86.747	87.098095	123.878264	85.096561	85.852193	117.393509	120.978442	127.500360	95.542041	98.075420	88.031839	93.239394	77.266331	98.607603	104.580969	122.148251	138.102741	106.586995	101.873418	93.062514	102.993981	91.338985	77.369974	107.480803	119.965774	121.477043	90.887745	115.380020	154.790291	111.461155	134.381253	167.155896	118.134920	119.908613	155.680371	153.965367	142.532602	98.891514	149.894171	166.434536	166.427467	163.446227	168.655740	176.944973	113.139654	110.791911	105.410538	142.633250	165.026322	164.713762	99.546130	99.212307	92.344711	79.478864	82.396244	76.862232	84.768520	93.384200	85.762864	73.396349	81.475792	117.484826	92.292761	93.866777	89.922193	73.863828	89.498419	73.858010	12.806440	79.982417	77.661255	77.120396	77.806959	79.072788	75.969988	70.581753	86.55337	88.560368	88.560368	86.903466	87.052317	77.123303	71.134928	71.144356	138.155880	135.571133	70.809433	131.320863	122.742185	133.029621	132.079507	69.536428	141.915342	141.193216	69.793491	102.770063	89.276737	74.516372	78.002641	90.706807	75.242806	82.263507	119.989435	106.080756	90.697257	119.289870	136.371241	86.644165	105.434999	100.468473	118.374904	86.297674	84.770125	87.518405	87.746617	87.819515	88.560368	142.752718	83.668912	58.518139	75.497791	142.375277	57.638007	83.491442	90.265952	77.195370	74.903623	99.339141	88.902003	84.915910	75.286313	89.139109	80.844765	82.462738	93.657659	79.722415	76.130904	94.709254	83.826180	91.033739	87.162749	87.117718	108.828674	85.414136	85.954131	88.413200	92.258366	97.879989	76.820730	86.338053	69.161648	72.185054	68.001136	78.804104	75.303155	90.692995	75.849699	76.495671	77.730679	81.128121	69.755897	71.978574	78.428787	81.939778	92.281266	90.417511	64.167677	97.404728	133.541803	86.311248	111.833425	138.025442	94.956428	96.115697	134.543353	118.168635	110.349777	77.559252	115.089875	132.390784	139.054057	137.687194	140.300314	139.783765	18.770473	95.751115	89.201599	109.792405	137.752886	137.567984	68.493260	88.451827	75.673787	79.927148	83.020362	56.321867	71.918488	86.675648	85.939824	74.291575	82.117994	82.335462	23.826581	68.904940	89.922193	125.734874	123.393370	126.446832	101.467644	122.433965	111.053709	107.100705	75.453630	79.903015	110.478036	103.794374	103.794374	87.380606	79.658700	80.371370	81.388812	123.257864	75.976294	119.985291	130.090871	125.734874	12.833535	20.400341	21.593572	22.095607	132.165465	58.449425	82.276006	11.523109	36.277198	34.132365	81.932672	55.913506	27.537439	28.060063	130.281481	65.609428	29.997359	21.216151	116.822938	27.814571	24.427722	11.177456	63.419749	34.820927	28.834709	76.462076
14	Presnel Kimpembe	Paris S-G	Centre-Back	fr Ligue 1	25	108.365101	66.070437	104.550733	106.902319	107.100605	90.265651	80.003089	90.087227	78.245294	74.666349	76.022121	69.738341	70.540487	101.354952	133.765141	76.126682	86.356753	88.560368	88.560368	86.178770	86.305053	101.893951	93.908207	93.955554	136.949234	129.558642	131.510083	124.705610	123.436194	159.480006	154.852314	127.718020	131.276886	128.097816	120.623519	98.147981	86.740956	136.087890	78.370521	75.885531	85.541623	79.795612	134.705465	90.123358	98.775643	113.552284	130.137029	96.941589	111.009983	76.052065	100.083323	82.743206	81.015092	86.660166	87.184756	87.493464	88.560368	140.561434	99.964793	65.247361	160.080752	72.667388	84.038965	89.497313	78.131401	66.944129	67.782939	72.664117	75.819671	97.177836	87.553619	100.761102	122.228549	81.715994	74.506776	79.444722	74.773523	109.932321	99.821237	119.533324	86.747	87.098095	81.475792	85.096561	85.852193	89.032906	84.722719	87.064585	92.792281	88.464184	85.689365	82.699479	99.211147	80.343346	84.239421	74.380666	48.720812	81.173583	86.420169	94.799729	74.568398	88.933771	77.369974	68.839028	96.144282	93.168189	87.213664	93.496803	124.995910	108.895602	103.737483	142.427071	94.069662	80.623293	125.737107	93.292093	94.498078	89.215888	94.782064	81.580173	133.691444	129.566872	129.118428	125.027763	94.866549	100.314948	88.965850	82.146909	135.446102	135.795637	103.972395	99.212307	99.564931	79.478864	82.396244	97.480434	110.696805	75.147122	85.762864	128.932698	81.475792	90.058365	87.358419	73.895937	112.683870	87.161894	73.533993	87.048412	10.512205	71.470899	77.350075	73.782021	75.116296	92.182164	111.920077	72.288652	86.55337	88.560368	88.560368	80.112210	80.134430	86.215390	93.499014	93.530273	132.758589	125.863362	78.585992	119.330576	117.597395	147.528860	143.739418	76.841156	126.379798	123.419703	76.627433	87.151313	69.616293	84.758607	78.002641	74.693585	86.452524	75.340798	125.309102	85.042404	93.419702	102.217743	126.342219	88.336879	101.457049	75.490282	83.701622	74.158104	79.985040	87.518405	87.746617	87.819515	88.560368	135.388553	86.568634	45.535768	145.306300	64.575976	66.694882	86.162055	73.267527	63.036751	52.589626	60.076000	68.690857	87.489697	79.638675	91.208663	106.888443	82.462738	73.711348	79.722415	76.130904	101.196907	89.748972	108.423772	87.162749	87.117718	81.895725	85.414136	85.954131	73.765182	70.710502	72.735254	81.934286	83.679868	73.923916	70.365446	78.369138	70.996858	66.895314	55.907943	68.385489	62.789172	73.109528	86.616121	51.076437	77.307713	78.428787	56.410814	80.977934	73.950401	70.500793	87.875448	122.648083	100.946714	90.741313	137.535810	86.041580	72.608703	123.663690	86.828387	87.739907	78.815455	87.681909	81.785407	128.319798	124.343050	122.203616	113.897829	17.438799	93.344934	83.486848	77.355953	130.470803	130.905631	74.693707	91.910056	87.952433	79.927148	83.020362	83.772185	101.807433	75.153769	85.939824	111.432937	82.117994	64.204492	25.351605	58.376319	112.683870	107.100605	127.540818	141.338121	101.467644	137.296512	95.439628	69.171157	87.162309	89.176896	100.320134	88.441220	88.441220	78.388923	86.455114	68.982414	80.561337	92.395181	60.813106	101.273964	126.117742	107.100605	14.100159	23.510741	23.192314	20.064027	139.200240	73.244516	98.596121	12.290143	22.363177	30.773470	65.426790	45.559131	24.868610	24.440723	112.307263	56.219759	31.327276	17.008481	104.555515	30.736463	26.819601	12.713791	70.269855	32.053772	21.782611	64.348588
18	Jean-Clair Todibo	Nice	Centre-Back	fr Ligue 1	21	70.663201	102.914367	121.780695	121.465087	122.226916	90.265651	123.451986	90.087227	114.799387	110.680008	94.376863	95.734432	95.180131	83.918060	82.942532	76.126682	86.356753	88.560368	88.560368	123.872936	124.982374	106.214975	56.620068	56.583276	134.237137	135.303438	101.614193	134.618157	130.653835	120.913136	121.786057	98.684848	142.233379	141.608348	109.126736	120.643236	126.037222	88.016687	78.370521	103.464594	65.690882	133.830757	140.612737	106.077675	89.264611	128.757420	136.325552	93.949943	123.915323	134.875966	122.555477	103.459657	86.067475	86.660166	87.184756	87.493464	88.560368	135.875610	100.751594	118.918491	79.812650	146.121906	123.660062	81.407992	122.696077	124.165950	132.552349	119.041520	106.265342	123.534306	101.113559	124.217887	100.367226	81.715994	135.847296	79.444722	74.773523	123.175028	105.869872	103.573812	86.747	87.098095	166.280736	85.096561	85.852193	130.483018	129.610756	139.294128	112.040596	88.464184	139.566261	139.351523	93.243697	132.526937	121.634994	128.891910	105.558552	128.149890	115.054130	89.588083	110.746413	103.365055	77.369974	109.320887	119.049563	127.465454	110.635934	71.613585	134.860492	111.033563	122.335942	143.624593	90.010462	107.952211	135.660964	96.485423	98.500955	87.953850	97.843848	81.580173	139.915899	141.233360	132.408672	144.256359	105.018274	79.361022	92.254787	93.488098	135.791061	136.405357	106.628154	94.076711	99.564931	79.478864	82.396244	91.136372	79.212458	75.147122	85.762864	101.164524	81.475792	121.007491	101.456539	113.837616	80.817522	84.860881	102.474324	84.766028	14.337673	95.814874	82.403200	81.066281	83.970503	82.944579	81.024005	69.337943	86.55337	88.560368	88.560368	105.289214	105.780888	83.410020	71.737717	71.747734	111.195323	112.499641	70.150548	113.176404	108.600698	96.677379	96.570796	69.632167	120.562803	120.216934	70.365942	100.178520	104.708959	69.361929	78.002641	91.469267	74.709062	108.881650	116.743553	92.462396	85.628283	104.384819	113.899710	81.826530	102.325215	114.461071	94.529153	87.710028	82.244032	87.518405	87.746617	87.819515	88.560368	112.937783	79.215846	94.670215	75.905850	122.780804	95.594246	79.983393	101.588703	107.217095	108.785844	96.247730	87.282003	100.932083	81.944464	102.031136	91.613387	82.462738	115.204797	79.722415	76.130904	104.445564	89.624635	91.820789	87.162749	87.117718	137.923177	85.414136	85.954131	102.273745	101.777822	110.634936	90.233759	81.291637	112.033912	109.997159	72.126379	103.879619	92.526115	99.530787	72.551574	98.459315	89.979379	79.767666	79.948697	82.013193	78.428787	85.206318	94.311759	100.558204	87.041282	71.727506	112.956742	88.656646	99.660110	119.211439	80.140517	89.089351	114.237262	85.531405	86.919777	74.502132	86.076263	81.785407	116.881667	119.733556	110.913438	118.220647	17.941038	80.851303	82.622531	81.836736	112.843849	113.729422	69.634026	86.199273	81.656304	79.927148	83.020362	69.619215	68.212655	75.153769	85.939824	89.648902	82.117994	90.999420	27.346307	87.422628	80.817522	122.226916	92.583756	98.831648	101.467644	94.872084	99.382557	98.411316	87.863139	82.203275	93.889182	101.481713	101.481713	104.488806	79.252084	87.862668	109.910117	125.238884	95.081718	125.284548	118.060967	122.226916	17.408256	21.637914	24.603958	18.777836	143.152014	52.531389	79.877696	13.535064	39.812315	32.648208	85.995587	47.288259	23.946711	22.182688	111.358696	57.411651	29.185888	18.492479	105.090018	27.852867	24.628080	10.404289	62.885236	42.312355	26.726805	83.376834
20	Rúben Dias	Manchester City	Centre-Back	eng Premier League	24	98.939626	84.492402	101.679072	102.048063	102.217528	107.444390	151.101284	107.009174	109.175680	96.274545	85.257947	102.615750	91.660182	95.542655	103.149111	82.876616	86.356753	88.560368	88.560368	118.847047	119.825398	101.893951	86.450579	86.481098	133.994263	128.887172	123.205669	133.857379	116.643815	123.577295	121.544697	116.947650	139.346195	136.675932	117.749323	123.350998	111.660539	124.697525	168.615281	166.502450	133.750566	124.006185	147.012282	86.134779	79.753578	115.306723	130.598285	84.120247	92.727417	134.875966	101.895594	101.658227	88.593667	86.660166	87.184756	87.493464	88.560368	135.744232	89.342981	89.907069	88.798580	132.904899	97.245998	83.655025	92.986293	86.018069	77.596486	82.259442	82.343743	123.534306	115.238496	126.824197	78.505902	81.715994	120.512166	79.444722	98.595592	149.660440	136.113045	135.492836	86.747	87.098095	166.280736	85.096561	85.852193	83.578944	95.081497	68.531521	103.791318	107.686655	69.292049	72.159564	71.298880	77.734166	74.993263	82.248268	127.101889	65.001411	85.056647	94.799729	75.860470	81.718129	77.369974	76.199366	81.484903	81.735768	84.917363	93.496803	123.892414	88.157387	99.680773	146.319017	96.099262	111.368326	125.222028	74.132112	78.486570	71.126676	73.349578	102.793764	132.308232	135.735360	145.039402	175.022114	109.078964	79.361022	82.387974	70.805720	135.359863	135.577880	102.201889	94.076711	92.344711	79.478864	82.396244	97.480434	79.212458	111.621278	85.762864	73.396349	81.475792	93.581030	86.653513	91.370422	85.130261	102.386575	142.676493	102.149830	15.446331	91.685408	81.921963	88.327856	85.594407	90.119156	95.247138	76.538473	86.55337	88.560368	88.560368	113.985029	114.638846	88.167173	88.057830	88.083777	136.707322	133.202226	80.096155	138.947580	115.148265	116.632772	114.601004	78.348589	143.981835	142.661275	78.688934	123.485346	109.240234	84.909693	153.462420	148.594221	124.426200	113.932792	144.277542	82.884958	80.135482	108.508457	135.091448	79.487155	84.859485	126.029003	91.132709	96.598547	85.792352	87.518405	87.746617	87.819515	88.560368	136.885855	79.591628	78.210380	85.557084	129.165734	85.694395	82.260606	87.317017	82.134971	65.478796	72.136613	75.615780	115.470574	94.359231	118.723378	80.844765	82.462738	114.068996	79.722415	93.048288	137.439916	111.870785	124.332217	87.162749	87.117718	154.554139	85.414136	85.954131	70.834135	84.543927	55.005846	95.010896	99.481625	59.015557	61.732930	72.779853	70.224042	59.417171	67.557148	83.689453	46.661318	74.283539	88.212007	55.806917	72.891810	78.428787	65.402346	65.388186	62.286285	70.887517	89.045199	130.264870	74.654570	90.584136	150.715122	89.042851	103.588006	132.122010	73.202080	77.221133	72.062545	72.610926	98.850501	133.926426	139.189989	147.246007	167.854917	20.242675	80.851303	79.803030	69.438063	137.882958	138.069295	76.778658	89.513063	84.084514	79.927148	83.020362	87.391143	72.615471	106.236940	85.939824	74.291575	82.117994	76.163001	26.138702	79.668349	85.130261	102.217528	142.649378	143.900749	101.467644	139.854194	92.597784	91.399259	99.643722	89.795626	91.018836	93.238040	93.238040	82.007698	97.684681	105.653252	73.899360	100.342263	52.807012	97.666687	125.508865	102.217528	14.177503	21.833956	21.867543	18.203767	136.587271	55.334670	81.473371	14.251634	27.022859	37.660254	78.934747	67.141967	27.837998	29.449201	144.671841	59.679651	36.069386	16.576992	112.326028	31.339436	27.541127	12.736454	71.617017	45.855538	31.076402	92.378271
24	Dayot Upamecano	Bayern Munich	Centre-Back	de Bundesliga	22	80.088676	93.703385	98.807412	97.193807	96.857369	90.265651	101.727537	90.087227	86.680854	74.666349	70.995026	82.736386	72.300462	93.605222	133.765141	90.526541	86.356753	88.560368	88.560368	83.665826	83.726565	84.609857	96.394083	96.447039	132.010789	130.304719	110.582960	135.588289	131.043658	116.092277	115.269349	108.518665	134.386161	135.174761	102.146546	138.139546	127.794372	118.326643	213.737662	127.103790	218.825171	114.181613	147.996827	114.054834	79.753578	136.944800	132.251121	81.983357	87.350192	115.267999	143.215360	112.466810	86.067475	86.660166	87.184756	87.493464	88.560368	132.021848	112.947007	102.962209	85.027283	137.711083	90.642481	83.655025	85.558847	95.555039	99.186289	133.434507	97.566579	108.159698	105.068541	111.186340	78.505902	81.715994	89.841906	79.444722	122.417660	149.660440	142.161680	167.411861	86.747	87.098095	81.475792	85.096561	85.852193	109.757962	105.440275	112.336945	106.541078	78.852948	95.059260	93.239394	95.361179	90.780064	117.114650	127.205995	112.892454	109.667409	123.235262	103.485807	83.612902	74.502487	77.369974	92.760127	109.887451	111.677824	83.539582	137.263238	126.366919	96.067840	111.663672	137.277727	105.957319	95.995810	127.934778	99.678753	90.495201	113.951835	97.843848	102.793764	137.195582	136.816029	129.363157	125.989193	127.352069	100.314948	85.676912	116.170476	131.349716	131.484049	101.316636	91.508912	85.124491	79.478864	82.396244	102.238481	86.620540	93.384200	85.762864	101.164524	81.475792	122.517204	101.456539	110.093084	84.171874	89.357188	98.965247	89.225932	12.377287	72.485285	76.076256	81.006822	76.445685	89.982445	117.854850	82.090319	86.55337	88.560368	88.560368	80.856503	80.892602	80.199481	95.800434	95.833939	143.572571	146.039004	81.598632	151.573598	145.088369	114.551312	113.906374	80.552952	146.876843	150.861669	80.175825	151.946979	142.309553	86.661355	200.970341	120.432129	200.617688	109.168310	153.811128	108.784224	80.135482	139.688306	148.074169	79.056936	81.987660	112.093330	157.018077	113.422850	84.580067	87.518405	87.746617	87.819515	88.560368	140.923759	107.823429	100.691437	83.066830	141.184108	82.571915	82.618157	82.442081	94.158816	95.892564	136.453386	92.349156	104.856689	91.628344	108.114847	80.844765	82.462738	88.326012	79.722415	112.888532	143.305511	118.979643	157.644367	87.162749	87.117718	81.895725	85.414136	85.954131	106.777608	101.048139	109.964662	101.994759	77.918062	89.931148	87.126665	81.968405	85.010559	115.203641	128.805052	84.067327	106.465519	120.837141	97.382858	70.778783	67.976893	78.428787	86.394420	112.035259	114.568200	73.106308	128.168617	146.855349	93.285622	123.180016	148.950806	98.999267	92.120390	148.916227	95.324783	87.486393	94.935428	93.509773	100.324690	150.189171	150.139926	136.188674	124.846629	24.328883	95.407429	83.465485	108.724368	141.820751	141.815102	79.487000	88.797701	79.828095	79.927148	83.020362	97.840034	82.635924	92.037934	85.939824	95.927972	82.117994	138.165168	34.282415	106.349614	84.171874	96.857369	131.688266	123.399727	55.119251	140.247914	148.117187	159.789539	94.071184	77.091945	141.709555	132.986523	132.986523	99.124330	119.695897	132.803370	104.772867	122.282686	85.981980	128.937705	130.968472	96.857369	14.621262	24.590522	20.393068	28.341911	171.275258	54.711718	88.994134	15.299214	51.522021	37.830297	104.651532	49.938652	30.027985	27.237735	131.533255	76.828568	38.452782	21.756845	137.038195	32.221181	28.061539	12.999203	73.281923	32.357041	27.636117	72.370445

In [319]:

#Filter the df to just see the attribute weightings and player info

newdf.drop(newdf.columns.difference(['Player','Squad','Main Position','Comp','Mins','Minutes (12.5%)','Defending (20%)','Aerial (20%)','Front Foot (5%)','Ball Carrying (15%)','Ball Playing (15%)','Ball Retention (10%)','Attacking Threat (2.5%)']), 1, inplace=True)

In [320]:

newdf.head()

Out[320]:

	Player	Squad	Main Position	Comp	Minutes (12.5%)	Defending (20%)	Aerial (20%)	Front Foot (5%)	Ball Carrying (15%)	Ball Playing (15%)	Ball Retention (10%)	Attacking Threat (2.5%)
0	William Saliba	Marseille	Centre-Back	fr Ligue 1	125.734874	132.165465	82.276006	81.932672	130.281481	116.822938	63.419749	76.462076
14	Presnel Kimpembe	Paris S-G	Centre-Back	fr Ligue 1	107.100605	139.200240	98.596121	65.426790	112.307263	104.555515	70.269855	64.348588
18	Jean-Clair Todibo	Nice	Centre-Back	fr Ligue 1	122.226916	143.152014	79.877696	85.995587	111.358696	105.090018	62.885236	83.376834
20	Rúben Dias	Manchester City	Centre-Back	eng Premier League	102.217528	136.587271	81.473371	78.934747	144.671841	112.326028	71.617017	92.378271
24	Dayot Upamecano	Bayern Munich	Centre-Back	de Bundesliga	96.857369	171.275258	88.994134	104.651532	131.533255	137.038195	73.281923	72.370445

In [321]:

#Weight the overall ratings
newdf['Minutes (12.5%)'] = newdf['Minutes (12.5%)'] *0.125
newdf['Defending (20%)'] = newdf['Defending (20%)'] *0.2
newdf['Aerial (20%)'] = newdf['Aerial (20%)'] *0.2
newdf['Front Foot (5%)'] = newdf['Front Foot (5%)'] *0.05
newdf['Ball Carrying (15%)'] = newdf['Ball Carrying (15%)'] *0.15
newdf['Ball Playing (15%)'] = newdf['Ball Playing (15%)'] *0.15
newdf['Ball Retention (10%)'] = newdf['Ball Retention (10%)'] *0.1
newdf['Attacking Threat (2.5%)'] = newdf['Attacking Threat (2.5%)'] *0.025


newdf['CB_Rating'] = newdf['Minutes (12.5%)'] + newdf['Defending (20%)'] + newdf['Aerial (20%)'] + newdf['Front Foot (5%)'] + newdf['Ball Carrying (15%)'] + newdf['Ball Playing (15%)'] + newdf['Ball Retention (10%)'] + newdf['Attacking Threat (2.5%)']

In [322]:

newdf

Out[322]:

	Player	Squad	Main Position	Comp	Minutes (12.5%)	Defending (20%)	Aerial (20%)	Front Foot (5%)	Ball Carrying (15%)	Ball Playing (15%)	Ball Retention (10%)	Attacking Threat (2.5%)	CB_Rating
0	William Saliba	Marseille	Centre-Back	fr Ligue 1	15.716859	26.433093	16.455201	4.096634	19.542222	17.523441	6.341975	1.911552	108.020977
14	Presnel Kimpembe	Paris S-G	Centre-Back	fr Ligue 1	13.387576	27.840048	19.719224	3.271340	16.846090	15.683327	7.026986	1.608715	105.383304
18	Jean-Clair Todibo	Nice	Centre-Back	fr Ligue 1	15.278365	28.630403	15.975539	4.299779	16.703804	15.763503	6.288524	2.084421	105.024337
20	Rúben Dias	Manchester City	Centre-Back	eng Premier League	12.777191	27.317454	16.294674	3.946737	21.700776	16.848904	7.161702	2.309457	108.356896
24	Dayot Upamecano	Bayern Munich	Centre-Back	de Bundesliga	12.107171	34.255052	17.798827	5.232577	19.729988	20.555729	7.328192	1.809261	118.816797
25	Facundo Medina	Lens	Centre-Back	fr Ligue 1	13.447211	24.115748	12.706187	4.592747	19.341411	18.880905	6.818244	1.787078	101.689531
30	Marc Guéhi	Crystal Palace	Centre-Back	eng Premier League	15.653716	29.694058	16.848821	3.466560	14.086131	13.091757	6.209951	1.943363	100.994358
31	Milan Škriniar	Inter	Centre-Back	it Serie A	15.401143	26.891602	15.931936	3.579735	13.985972	12.571144	6.399427	2.208200	96.969160
35	Nayef Aguerd	Rennes	Centre-Back	fr Ligue 1	13.945341	33.636712	22.053565	3.430595	13.535603	13.490352	6.694817	2.201796	108.988781
39	Jules Koundé	Sevilla	Centre-Back	es La Liga	13.948849	32.626703	19.419828	3.587328	16.982721	15.563235	6.657644	2.081727	110.868036
43	Robin Le Normand	Real Sociedad	Centre-Back	es La Liga	16.032575	35.599374	23.450266	3.466105	13.896387	12.135661	6.180854	1.843785	112.605008
44	Nikola Milenković	Fiorentina	Centre-Back	it Serie A	14.615361	36.787933	24.570948	3.681472	13.263461	13.137054	6.485420	2.067530	114.609178
47	Warmed Omari	Rennes	Centre-Back	fr Ligue 1	14.159326	28.128638	20.499039	3.518381	14.049861	13.295942	6.714624	1.457000	101.822812
53	Joachim Andersen	Crystal Palace	Centre-Back	eng Premier League	14.580281	30.140148	19.282114	3.231593	12.929163	14.872614	6.385955	1.695190	103.117059
58	Manuel Akanji	Dortmund	Centre-Back	de Bundesliga	12.282569	31.444636	17.964726	4.693285	17.068106	17.067667	7.247872	2.097063	109.865924
60	Gabriel Dos Santos	Arsenal	Centre-Back	eng Premier League	15.095951	27.640316	17.746816	3.544714	15.904865	12.505276	6.368592	2.359393	101.165924
61	Éder Militão	Real Madrid	Centre-Back	es La Liga	14.983696	32.456461	21.747197	3.628726	13.693620	13.004264	6.420798	2.408475	108.343237
62	Lucas Hernández	Bayern Munich	Centre-Back	de Bundesliga	11.472231	29.532163	18.731862	4.974879	20.204177	22.279606	7.558836	1.540685	116.294439
64	Joško Gvardiol	RB Leipzig	Centre-Back	de Bundesliga	12.801747	32.185168	18.193658	4.684021	18.376047	19.860577	6.841540	2.460039	115.402798
68	Pau Torres	Villarreal	Centre-Back	es La Liga	14.366296	29.392613	18.296843	3.238139	19.181368	18.004611	6.488391	2.456209	111.424470
73	Jonathan Tah	Leverkusen	Centre-Back	de Bundesliga	14.446979	34.392444	22.632803	3.735318	13.494624	13.243570	6.532724	1.829866	110.308329
75	Roger Ibanez	Roma	Centre-Back	it Serie A	14.485566	29.261345	20.046387	3.822280	15.915563	13.039665	6.463605	2.173931	105.208343
77	Luiz Felipe	Lazio	Centre-Back	it Serie A	13.089399	30.024717	15.232774	3.795639	13.100037	13.032799	6.973087	1.385443	96.633895
80	Duje Ćaleta-Car	Marseille	Centre-Back	fr Ligue 1	11.566946	26.501669	21.067088	3.339784	17.092462	15.040239	7.649963	2.090786	104.348936
87	Kevin Danso	Lens	Centre-Back	fr Ligue 1	14.138278	32.628596	21.169927	4.142805	14.858010	11.224935	6.566369	1.814754	106.543675
89	Alessandro Bastoni	Inter	Centre-Back	it Serie A	12.457967	29.768506	18.127429	4.657726	16.141220	16.962895	7.134390	1.678426	106.928558
93	Nico Elvedi	M'Gladbach	Centre-Back	de Bundesliga	12.875414	35.501174	20.018010	3.864365	12.452584	10.714605	7.093725	1.969216	104.489092
94	Obite N'Dicka	Eint Frankfurt	Centre-Back	de Bundesliga	14.373312	39.136129	21.313221	4.610146	13.163875	12.857885	6.413137	2.355787	114.223491
95	Niklas Süle	Bayern Munich	Centre-Back	de Bundesliga	10.795195	33.230609	21.686631	4.162750	18.642950	20.289471	8.005998	2.223577	119.037181
96	Çağlar Söyüncü	Leicester City	Centre-Back	eng Premier League	13.110447	36.577024	20.518961	4.018093	12.888439	11.581759	6.790443	1.766829	107.251996
100	Eric García	Barcelona	Centre-Back	es La Liga	11.503803	26.365709	14.294599	4.374772	18.824901	18.736696	7.689267	1.460303	103.250050
102	Igor	Fiorentina	Centre-Back	it Serie A	12.215918	31.967718	14.693123	4.369614	14.739520	13.834983	7.331462	1.538892	100.691229
105	Waldemar Anton	Stuttgart	Centre-Back	de Bundesliga	13.454227	32.807830	17.457085	4.434074	14.985923	14.142541	6.711572	2.168148	106.161401
106	Ben White	Arsenal	Centre-Back	eng Premier League	14.453995	28.860857	16.702385	3.462523	14.250578	13.714672	6.421569	1.699529	99.566109
107	Axel Disasi	Monaco	Centre-Back	fr Ligue 1	13.896229	32.846646	19.773649	4.122689	15.392975	15.009886	6.657106	2.116367	109.815547
108	Gianluca Mancini	Roma	Centre-Back	it Serie A	14.446979	29.176499	18.552994	4.367871	14.627451	15.751006	6.448410	2.225298	105.596507
115	Castello Lukeba	Lyon	Centre-Back	fr Ligue 1	11.700248	31.503535	16.966864	4.330517	14.133492	13.938231	7.517130	1.874443	101.964461
119	Fikayo Tomori	Milan	Centre-Back	it Serie A	13.885706	28.951420	13.864707	4.718894	11.950488	11.884750	6.652956	1.958232	93.867152
121	Matthijs de Ligt	Juventus	Centre-Back	it Serie A	13.731355	35.706630	21.612680	4.056626	13.105808	11.346136	6.727030	2.152877	108.439143
122	Hiroki Ito	Stuttgart	Centre-Back	de Bundesliga	12.587761	31.257929	16.388019	4.200921	14.187271	17.130047	6.925842	1.628915	104.306705
124	Philipp Lienhart	Freiburg	Centre-Back	de Bundesliga	14.418915	33.114410	18.662083	3.132023	13.376509	12.702525	6.458779	2.196297	104.061541
125	Ronald Araújo	Barcelona	Centre-Back	es La Liga	12.321157	33.490562	21.998866	4.043771	16.250626	13.852010	7.216454	2.132918	111.306364
127	Konstantinos Mavropanos	Stuttgart	Centre-Back	de Bundesliga	13.840102	39.937172	26.446764	4.386967	14.063059	15.359827	6.513724	2.579430	123.127045
156	Pietro Ceccaroni	Venezia	Centre-Back	it Serie A	15.302920	27.717338	16.556832	3.655985	12.378391	11.862545	6.179307	1.977821	95.631140
159	Nico Schlotterbeck	Freiburg	Centre-Back	de Bundesliga	14.120739	39.999562	24.275143	4.473484	15.670643	17.384120	6.443620	3.049170	125.416481
166	Catena	Rayo Vallecano	Centre-Back	es La Liga	15.716859	34.585195	22.349405	3.253493	10.518959	11.536535	6.149861	1.987267	106.097576
170	Mohammed Salisu	Southampton	Centre-Back	eng Premier League	14.776727	37.806127	21.723955	4.462757	13.775680	15.226593	6.131913	2.088765	115.992518
175	Alexander Djiku	Strasbourg	Centre-Back	fr Ligue 1	13.801515	29.789821	20.679525	3.874064	14.170459	17.545926	6.596303	2.024769	108.482381
182	Dimitris Nikolaou	Spezia	Centre-Back	it Serie A	15.716859	25.446230	11.773046	3.826233	12.990062	11.877846	6.109579	1.281095	89.020950
184	Daniel Amartey	Leicester City	Centre-Back	eng Premier League	11.798471	28.229341	14.488662	3.539288	13.691045	12.019610	7.492279	1.273232	92.531928
185	Jean-Kevin Duverne	Brest	Centre-Back	fr Ligue 1	14.899505	22.637288	13.784031	4.558038	15.670891	18.134471	6.097696	1.920797	97.702718
196	Tiago Djaló	Lille	Centre-Back	fr Ligue 1	12.521110	22.095522	10.999051	4.314026	14.062256	12.318633	7.083545	1.863075	85.257217
197	Sven Botman	Lille	Centre-Back	fr Ligue 1	12.243982	32.406781	22.107778	3.918409	12.538233	13.026307	7.225174	2.017910	105.484574
215	Max Kilman	Wolves	Centre-Back	eng Premier League	13.776959	32.343870	19.925937	3.823547	14.533584	13.453087	6.624035	1.758450	106.239469
220	Joseph Aidoo	Celta Vigo	Centre-Back	es La Liga	13.601561	30.939041	17.500575	4.164740	14.053441	14.440202	6.604786	1.439677	102.744022
223	Edmond Tapsoba	Leverkusen	Centre-Back	de Bundesliga	10.714512	31.772960	17.574875	4.512106	16.225454	13.291590	7.969325	1.691911	103.752733
226	Wout Faes	Reims	Centre-Back	fr Ligue 1	16.032575	26.044732	14.415663	3.297669	11.390601	10.636223	6.173301	2.056616	90.047379
236	Maxence Lacroix	Wolfsburg	Centre-Back	de Bundesliga	13.089399	37.495454	20.527640	4.148045	13.960636	14.400285	6.741857	1.953135	112.316450
240	Arthur Theate	Bologna	Centre-Back	it Serie A	12.854366	25.948114	11.173983	3.900427	15.013535	14.742907	6.827858	2.033632	92.494822
244	Moussa Niakhate	Mainz 05	Centre-Back	de Bundesliga	13.356004	29.784024	18.806703	4.583265	12.327730	16.149345	6.503980	2.006909	103.517960
254	Lucas Perrin	Strasbourg	Centre-Back	fr Ligue 1	13.127987	27.177144	18.618954	4.059844	15.915557	17.984241	6.803427	1.484633	105.171787
256	Gerzino Nyamsi	Strasbourg	Centre-Back	fr Ligue 1	14.818822	30.897031	20.275501	3.580602	12.308260	11.333519	6.340264	2.221608	101.775607
259	Mohamed Simakan	RB Leipzig	Centre-Back	de Bundesliga	11.398564	32.970236	22.382861	4.560271	14.758192	14.124348	7.493044	1.973989	109.661506
260	Benoît Badiashile	Monaco	Centre-Back	fr Ligue 1	10.798703	36.719311	24.562662	4.579034	12.592597	16.119535	7.937538	2.163928	115.473308
268	Gleison Bremer	Torino	Centre-Back	it Serie A	14.489074	43.095735	18.791576	5.328428	11.002032	10.635605	6.396376	2.830339	112.569164
273	Jan Bednarek	Southampton	Centre-Back	eng Premier League	13.573497	39.026030	21.174121	3.567034	10.009396	11.184073	6.580709	2.244442	107.359302
285	Andreas Christensen	Chelsea	Centre-Back	eng Premier League	9.598982	39.104087	19.587848	4.100308	15.491279	17.185164	8.909534	1.532960	115.510161
294	Luca Kilian	Köln	Centre-Back	de Bundesliga	12.352728	32.046638	16.342027	4.501243	11.821678	12.494273	7.025124	1.683860	98.267570
295	Thilo Kehrer	Paris S-G	Centre-Back	fr Ligue 1	9.658617	28.759734	17.939416	4.679439	14.567748	12.309349	8.996904	2.091743	99.002950
303	Trevoh Chalobah	Chelsea	Centre-Back	eng Premier League	9.434108	31.092471	16.188201	4.886599	16.718658	16.345935	8.987556	1.949681	105.603209
306	Stefan Posch	Hoffenheim	Centre-Back	de Bundesliga	12.065076	29.719436	12.063887	4.952963	14.423304	15.533270	7.053046	1.919511	97.730493
307	Nicolas Cozza	Montpellier	Centre-Back	fr Ligue 1	14.068119	25.036395	13.801977	4.269358	13.626068	12.127502	6.431421	1.880354	91.241195
311	Mario Hermoso	Atlético Madrid	Centre-Back	es La Liga	10.893418	30.133749	20.586828	4.098120	15.470264	16.636253	7.775186	2.512253	108.106070
320	Cristian Romero	Tottenham	Centre-Back	eng Premier League	10.819751	33.479567	17.919203	5.446110	15.741264	13.228069	7.828130	1.768431	106.230526
323	Rodrigo Becão	Udinese	Centre-Back	it Serie A	15.330984	27.331659	18.405454	4.907179	11.520100	10.340645	6.102945	1.941153	95.880119
325	Martin Valjent	Mallorca	Centre-Back	es La Liga	15.509890	28.432812	18.905413	3.274789	12.084950	10.848701	6.199259	1.377735	96.633550
341	Tuta	Eint Frankfurt	Centre-Back	de Bundesliga	12.008948	31.714585	17.395910	5.075000	13.712856	13.225559	7.076190	2.309572	102.518621
365	Pascal Struijk	Leeds United	Centre-Back	eng Premier League	11.559930	31.651441	15.475376	5.324431	11.503198	13.313083	7.446744	1.904198	98.178401
375	Jean-Charles Castelletto	Nantes	Centre-Back	fr Ligue 1	13.156050	30.643276	20.215396	3.721145	11.046502	13.096615	6.816295	1.867915	100.563194
379	Brendan Chardonnet	Brest	Centre-Back	fr Ligue 1	13.773451	34.801443	20.140329	3.774123	12.007840	12.415188	6.628863	1.817212	105.358449
385	Timo Hübers	Köln	Centre-Back	de Bundesliga	10.454923	41.818180	20.720843	5.473952	13.188416	13.303136	8.020724	2.020771	115.000946
396	Koray Günter	Hellas Verona	Centre-Back	it Serie A	12.808763	39.795914	20.790492	3.770139	11.555260	13.255613	6.830481	1.501192	110.307854
399	Lucas Martínez Quarta	Fiorentina	Centre-Back	it Serie A	9.370964	35.848414	20.519892	4.756569	18.775452	15.060016	9.146225	2.459191	115.936724
406	Lilian Brassier	Brest	Centre-Back	fr Ligue 1	12.289585	28.683291	18.230053	4.211084	13.946986	14.964261	7.034724	1.927435	101.287418
415	Sebastiaan Bornauw	Wolfsburg	Centre-Back	de Bundesliga	11.391548	35.532743	19.806146	4.304308	9.684306	9.487634	7.445881	2.094371	99.746938
418	Juan Foyth	Villarreal	Centre-Back	es La Liga	11.100387	28.691300	19.509719	4.974252	16.512417	15.852662	7.547831	1.695367	105.883934
419	Piero Hincapié	Leverkusen	Centre-Back	de Bundesliga	10.504035	35.000784	17.348548	5.467242	17.720149	14.435930	7.859769	1.809943	110.146398
427	Mickael Nade	Saint-Étienne	Centre-Back	fr Ligue 1	13.341972	31.010904	18.993182	4.611683	12.472368	12.103190	6.627284	1.578035	100.738619
445	Odilon Kossonou	Leverkusen	Centre-Back	de Bundesliga	10.640845	28.521069	13.827007	4.512062	12.991078	12.054413	7.890313	1.405096	91.841885
452	Davinson Sánchez	Tottenham	Centre-Back	eng Premier League	10.072556	35.416318	18.047064	4.615017	16.683720	14.734986	8.391907	2.553029	110.514597
460	Nicolò Casale	Hellas Verona	Centre-Back	it Serie A	13.422655	32.137434	17.152518	4.728785	13.035082	13.017418	6.586329	1.702365	101.782586
467	Dylan Bronn	Metz	Centre-Back	fr Ligue 1	13.278829	24.442242	12.503434	4.073558	11.778920	11.331249	6.695227	1.874387	85.977846
489	Timo Baumgartl	Union Berlin	Centre-Back	de Bundesliga	11.949313	34.215618	18.522723	5.359793	11.490573	14.181491	7.038935	2.135915	104.894362
491	Boubakar Kouyaté	Metz	Centre-Back	fr Ligue 1	13.699784	38.547907	22.357439	4.641085	10.719144	9.898477	6.572527	2.121819	108.558182
493	Adam Webster	Brighton	Centre-Back	eng Premier League	9.381488	40.297614	25.441689	4.239445	17.903479	17.147010	8.648600	2.123608	125.182932
502	Reece Oxford	Augsburg	Centre-Back	de Bundesliga	13.798007	37.120966	19.967089	3.640767	10.065776	10.224729	6.464715	2.190515	103.472563
504	Florian Grillitsch	Hoffenheim	Centre-Back	de Bundesliga	9.598982	26.681047	14.138540	5.141156	16.710560	19.852708	8.874288	1.645153	102.642433
525	Paul Jaeckel	Union Berlin	Centre-Back	de Bundesliga	11.531866	31.337291	15.149262	4.708857	12.099800	12.678109	7.270897	1.333987	96.110070
533	Amos Pieper	Arminia	Centre-Back	de Bundesliga	12.696508	34.692781	18.490891	4.241931	10.353086	11.868419	6.761276	1.746159	100.851051
544	Hugo Guillamón	Valencia	Centre-Back	es La Liga	12.633365	27.133738	14.784808	4.417726	11.913831	16.117460	6.859506	1.456853	95.317286
566	Takehiro Tomiyasu	Arsenal	Centre-Back	eng Premier League	10.240938	31.762454	15.873903	4.371856	14.973144	15.890046	7.895978	1.993485	103.001804
573	Alessio Romagnoli	Milan	Centre-Back	it Serie A	9.293789	35.736977	20.368610	4.479934	12.256256	14.868803	9.048647	2.106315	108.159332
582	Atakan Karazor	Stuttgart	Centre-Back	de Bundesliga	11.009181	33.043301	17.808724	5.471192	11.540118	15.033220	7.593610	1.634801	103.134149
598	Martin Erlic	Spezia	Centre-Back	it Serie A	13.387576	33.315558	16.799458	3.810521	9.521136	9.292547	6.603722	2.178477	94.908994
604	Ezri Konsa	Aston Villa	Centre-Back	eng Premier League	13.040288	28.756222	16.197950	3.527675	10.158820	9.468765	6.841113	2.107104	90.097936
610	Rober	Levante	Centre-Back	es La Liga	11.402072	26.875586	11.203422	4.437315	13.273751	13.282203	7.375291	1.883177	89.732817
612	Kurt Zouma	West Ham	Centre-Back	eng Premier League	11.640613	31.708675	19.789064	3.152019	10.772730	9.855120	7.447427	1.743249	96.108896
614	Niklas Stark	Hertha BSC	Centre-Back	de Bundesliga	11.475739	35.991394	21.417478	4.429206	11.276147	11.666991	7.370437	1.746694	105.374086
619	Chris Richards	Hoffenheim	Centre-Back	de Bundesliga	8.925454	44.607179	22.600588	5.690145	13.847462	14.739260	9.328075	2.377509	122.115672
622	Johan Vásquez	Genoa	Centre-Back	it Serie A	12.345712	31.729509	16.066928	5.208792	11.715333	12.192596	6.663108	1.965515	97.887493
627	Louis Beyer	M'Gladbach	Centre-Back	de Bundesliga	9.206090	25.436121	11.872542	4.833949	14.553405	12.655251	9.134561	1.815725	89.507644
630	Harold Moukoudi	Saint-Étienne	Centre-Back	fr Ligue 1	10.177795	28.295519	17.125842	5.098715	12.415621	11.529241	8.442855	1.781848	94.867435
637	Sebastiano Luperto	Empoli	Centre-Back	it Serie A	11.219658	33.770637	14.320736	3.864979	12.719905	13.007442	7.529174	1.714759	98.147290
638	Yeray Álvarez	Athletic Club	Centre-Back	es La Liga	10.875878	36.046106	18.736356	4.345827	13.180952	13.352606	7.702986	1.613594	105.854305
642	José María Giménez	Atlético Madrid	Centre-Back	es La Liga	11.514326	28.248623	18.206009	3.544316	10.067548	10.535768	7.567705	2.083011	91.767306
648	Dan-Axel Zagadou	Dortmund	Centre-Back	de Bundesliga	7.690653	46.013899	26.383880	4.686887	15.790944	15.248704	11.440162	1.593677	128.848805
663	Andrea Carboni	Cagliari	Centre-Back	it Serie A	12.121203	29.185793	16.044319	4.383020	13.823148	14.791316	6.880455	1.633413	98.862668
673	Daniel Vivian	Athletic Club	Centre-Back	es La Liga	11.317881	25.851591	9.047421	3.993928	11.153679	10.708528	7.507273	2.235381	81.815682
689	Kaan Ayhan	Sassuolo	Centre-Back	it Serie A	9.100852	29.649553	14.206732	4.007950	14.873445	16.903859	9.418207	1.504744	99.665341
693	Stian Rode Gregersen	Bordeaux	Centre-Back	fr Ligue 1	11.202118	30.789953	17.016467	4.906325	12.412027	11.366069	7.542203	1.877672	97.112834
710	Nathan Aké	Manchester City	Centre-Back	eng Premier League	7.588922	40.385415	26.994063	4.644321	20.162675	15.020448	11.868488	2.318636	128.982969
719	Flavius Daniliuc	Nice	Centre-Back	fr Ligue 1	8.886866	27.979350	13.568696	5.202229	13.626837	13.924718	9.556505	1.522011	94.267213
722	Anel Ahmedhodzic	Bordeaux	Centre-Back	fr Ligue 1	9.086820	27.238952	19.463581	4.393142	15.865445	14.635659	9.302797	1.850969	101.837365
752	Leonardo Balerdi	Marseille	Centre-Back	fr Ligue 1	7.683637	31.330187	17.478640	4.949218	16.049572	12.886833	11.779167	1.377155	103.534410
753	Jorge Cuenca	Getafe	Centre-Back	es La Liga	13.762927	32.598207	19.504602	3.535382	9.605625	10.967448	6.209650	1.785986	97.969826
762	Clément Lenglet	Barcelona	Centre-Back	es La Liga	7.248650	33.431754	12.088267	6.494039	24.638687	22.464947	12.846648	1.480232	120.693224
783	Andrew Gravillon	Reims	Centre-Back	fr Ligue 1	11.840566	25.130108	15.590854	3.663191	12.010053	13.586607	6.984696	1.752046	90.558121
785	Maximilian Bauer	Greuther Fürth	Centre-Back	de Bundesliga	10.279525	35.909959	18.823340	4.683575	9.982383	9.170085	8.026687	1.592052	98.467605
787	Kevin Akpoguma	Hoffenheim	Centre-Back	de Bundesliga	9.707728	24.477289	12.646994	4.660334	14.726727	17.501073	8.142356	2.522420	94.384920
811	Merih Demiral	Atalanta	Centre-Back	it Serie A	11.075832	41.493220	24.338016	5.449278	9.870867	9.366811	7.683529	2.739242	112.016795
813	Maxime Estève	Montpellier	Centre-Back	fr Ligue 1	10.865354	29.215022	14.323554	4.299900	11.234573	10.050548	7.762762	1.704859	89.456572
816	Víctor Chust	Cádiz	Centre-Back	es La Liga	10.770639	25.240048	9.240105	4.259092	12.347235	10.506189	7.885204	1.815380	82.063893
817	Jason Denayer	Lyon	Centre-Back	fr Ligue 1	7.866051	31.127341	11.535210	4.217519	11.325274	10.705983	11.529459	2.467243	90.774080
824	Luca Ranieri	Salernitana	Centre-Back	it Serie A	11.728312	22.578238	12.267148	3.652020	12.892418	15.753565	6.825698	1.800126	87.497525
827	Karim Rekik	Sevilla	Centre-Back	es La Liga	8.202815	30.275007	16.785403	5.312960	12.568103	12.384291	10.594634	1.884036	98.007249
846	Maxim Leitsch	Bochum	Centre-Back	de Bundesliga	9.746316	34.589247	17.447277	4.664815	12.276874	12.565730	8.458565	1.798838	101.547663
879	Óscar Mingueza	Barcelona	Centre-Back	es La Liga	7.487191	24.515804	14.491705	5.936294	15.871025	17.577118	11.793413	1.656232	99.328783
886	Ibrahima Konaté	Liverpool	Centre-Back	eng Premier League	7.823955	40.098126	22.889298	4.136037	14.804313	16.976386	11.239402	1.633089	119.600606
889	Loïc Bade	Rennes	Centre-Back	fr Ligue 1	7.806416	34.772877	19.994685	3.673546	17.380911	13.789754	11.510346	1.803837	110.732372
930	Kristoffer Ajer	Brentford	Centre-Back	eng Premier League	11.349452	31.985852	18.525606	4.106609	13.876729	14.334974	7.018935	1.958235	103.156392
937	Abdou Diallo	Paris S-G	Centre-Back	fr Ligue 1	7.427556	27.329398	21.597591	5.821752	20.012184	19.117025	12.064824	1.665741	115.036071
964	Ardian Ismajli	Empoli	Centre-Back	it Serie A	8.813199	33.727031	21.366491	4.229688	13.513178	14.304754	9.493237	1.572920	107.020499
966	Ben Godfrey	Everton	Centre-Back	eng Premier League	11.468723	30.077308	16.421744	4.442894	12.005027	12.224582	7.077249	2.145981	95.863508
972	Nehuén Pérez	Udinese	Centre-Back	it Serie A	10.286541	27.570084	12.889473	5.066554	12.405383	11.272290	7.821229	2.115846	89.427399
989	Diego González	Elche	Centre-Back	es La Liga	10.640845	27.546833	12.861433	3.718288	9.460091	9.631553	7.831395	1.422635	83.113073
996	Moritz Jenz	Lorient	Centre-Back	fr Ligue 1	9.195567	30.375655	16.680739	4.746650	12.698829	10.808441	9.049895	2.076239	95.632015
998	Armel Bella Kotchap	Bochum	Centre-Back	de Bundesliga	10.553146	36.169394	22.438481	4.642010	11.221910	10.603965	7.637691	1.783874	105.050471
1009	Omar Alderete	Valencia	Centre-Back	es La Liga	12.780699	35.615999	21.997811	4.230891	11.675954	13.458222	6.420594	1.882930	108.063100
1018	Mattia Viti	Empoli	Centre-Back	it Serie A	9.581442	32.408968	11.100376	4.765763	12.376448	11.853666	8.612624	1.560155	92.259443
1023	Mason Holgate	Everton	Centre-Back	eng Premier League	11.837058	33.354624	21.001880	4.003468	9.705001	10.645970	6.820762	1.757564	99.126327
1026	Giorgio Altare	Cagliari	Centre-Back	it Serie A	9.493743	32.437375	15.845370	5.029320	12.438920	15.504574	8.078997	2.545275	101.373573
1050	Kevin Bonifazi	Bologna	Centre-Back	it Serie A	8.595706	32.495271	19.977805	4.998402	13.920557	14.606069	9.599287	1.953538	106.146634
1060	Pascal Stenzel	Stuttgart	Centre-Back	de Bundesliga	7.504731	26.024586	12.377301	5.868517	14.165446	19.430042	11.587014	1.766586	98.724224
1064	Jakub Kiwior	Spezia	Centre-Back	it Serie A	11.240706	27.316420	15.024245	5.471208	9.537635	10.622435	7.309197	1.678017	88.199864
1066	Domingos Duarte	Granada	Centre-Back	es La Liga	10.269002	32.397151	18.857826	3.751167	10.124534	11.289637	7.835548	1.719760	96.244625
1069	Marin Pongračić	Dortmund	Centre-Back	de Bundesliga	7.252158	33.186823	15.784682	6.308213	14.947683	12.007578	12.637670	1.165650	103.290458
1073	Marash Kumbulla	Roma	Centre-Back	it Serie A	7.946734	33.894229	19.313603	6.053579	12.788080	11.042732	10.846333	2.076032	103.961322
1083	Erik Palmer-Brown	Troyes	Centre-Back	fr Ligue 1	10.433876	30.723854	18.380165	4.734613	10.194522	10.425763	7.917331	1.502775	94.312898
1084	Mouctar Diakhaby	Valencia	Centre-Back	es La Liga	11.184578	30.498439	16.088945	4.450333	11.019335	11.934016	7.320262	1.715356	94.211263
1100	Christopher Wooh	Lens	Centre-Back	fr Ligue 1	8.034433	32.994356	18.361825	6.123841	15.406241	11.738479	10.763402	2.252968	105.675545
1107	Robin Koch	Leeds United	Centre-Back	eng Premier League	9.872602	32.808280	16.143168	5.159055	9.886927	12.141029	8.049806	1.951562	96.012429
1110	Fernando Calero	Espanyol	Centre-Back	es La Liga	8.174751	30.444883	13.174307	5.247619	12.297243	12.151674	10.310201	1.299270	93.099949
1116	Paweł Dawidowicz	Hellas Verona	Centre-Back	it Serie A	8.553610	32.181754	16.153793	5.481804	14.888225	12.582280	9.869213	1.870217	101.580895
1126	David Zima	Torino	Centre-Back	it Serie A	8.960533	40.239499	20.988293	4.759080	11.713106	10.183220	9.287396	1.877053	108.008181
1139	Michael Svoboda	Venezia	Centre-Back	it Serie A	8.686913	33.862896	15.064578	4.835119	13.481383	13.033460	9.659847	2.062289	100.686485
1155	Erhan Mašović	Bochum	Centre-Back	de Bundesliga	9.795427	32.250547	14.527884	4.460860	9.676336	9.872383	8.107428	1.500726	90.191591
1162	Petko Hristov	Spezia	Centre-Back	it Serie A	8.729008	36.782223	20.701646	4.174271	10.659464	11.016302	9.456716	1.422661	102.942292
1172	Franco Russo	Mallorca	Centre-Back	es La Liga	9.486727	30.497559	15.947160	3.964905	10.327746	11.526537	8.306229	1.716880	91.773744
1197	Matteo Lovato	Cagliari	Centre-Back	it Serie A	8.693929	33.741738	16.321652	4.910963	9.551871	10.839899	9.448760	1.585713	95.094525
1206	Saidou Sow	Saint-Étienne	Centre-Back	fr Ligue 1	7.820447	34.612281	19.486049	6.478290	13.259905	13.458639	10.841643	1.698817	107.656072
1209	Marc-Oliver Kempf	Stuttgart	Centre-Back	de Bundesliga	7.297762	43.400517	21.099373	6.276848	15.493244	16.633145	12.000770	2.886563	125.088221
1217	Marvin Friedrich	Union Berlin	Centre-Back	de Bundesliga	8.451880	38.544432	18.049350	4.709653	11.728402	12.982012	9.359762	2.599315	106.424804
1227	Nathan Collins	Burnley	Centre-Back	eng Premier League	10.209366	41.649420	22.048188	3.900314	10.458903	12.551625	7.589830	2.651434	111.059080
1231	Timothee Pembele	Bordeaux	Centre-Back	fr Ligue 1	9.311329	21.650164	12.197752	4.707981	16.840310	13.217451	8.172951	3.108631	89.206569
1260	Raúl Torrente	Granada	Centre-Back	es La Liga	8.848279	29.047529	12.351265	4.823804	11.631615	10.992529	8.949569	1.503643	88.148233
1266	Alessandro Buongiorno	Torino	Centre-Back	it Serie A	8.493975	41.544495	21.656152	5.121135	12.380122	11.739631	9.527609	1.832158	112.295279
1325	Rob Holding	Arsenal	Centre-Back	eng Premier League	7.315302	40.705942	17.097179	4.235484	11.283095	10.336805	12.294315	1.713300	104.981422
1331	Giorgio Scalvini	Atalanta	Centre-Back	it Serie A	7.027649	36.053557	20.066743	5.909271	13.667563	19.265420	12.589352	4.145224	118.724778
1354	Issa Diop	West Ham	Centre-Back	eng Premier League	7.729240	29.062900	12.566112	4.817995	11.432247	10.044518	11.082595	1.435478	88.171085
1362	Leo Skiri Østigård	Genoa	Centre-Back	it Serie A	8.462404	46.991569	26.877978	4.224490	11.346076	12.575785	9.238683	1.800850	121.517834
1389	Mads Bech Sørensen	Brentford	Centre-Back	eng Premier League	7.280222	30.336154	15.133021	5.176276	12.761651	11.877560	11.638209	1.547398	95.750491
1401	Bosko Sutalo	Hellas Verona	Centre-Back	it Serie A	7.578398	38.580102	17.736757	5.538200	12.859797	13.495585	10.915616	1.824803	108.529258
1405	Nikola Maraš	Rayo Vallecano	Centre-Back	es La Liga	8.013385	37.826372	18.646555	5.072564	10.380656	11.298366	10.540153	1.583840	103.361891
1458	Andrés Andrade Cedeño	Arminia	Centre-Back	de Bundesliga	8.020401	33.708648	15.444934	5.620179	13.703138	13.629569	9.293727	1.991916	101.412511
1491	Ozan Kabak	Norwich City	Centre-Back	eng Premier League	7.585414	35.491352	17.510948	5.415056	11.287634	10.626094	11.077482	1.569556	100.563536
1514	Zinho Vanheusden	Genoa	Centre-Back	it Serie A	7.820447	35.835666	16.337328	4.745372	12.138514	10.847832	10.594680	1.773131	100.092970
1518	Ohis Felix Uduokhai	Augsburg	Centre-Back	de Bundesliga	7.111840	37.563185	22.263007	5.998028	11.920613	13.893504	12.202213	1.420961	112.373351
1557	Marc-Oliver Kempf	Hertha BSC	Centre-Back	de Bundesliga	8.037941	38.947397	21.013979	4.583755	10.517192	13.240122	9.841686	2.130352	108.312424
1565	Guilherme Ramos	Arminia	Centre-Back	de Bundesliga	7.529287	40.228413	18.415329	5.465007	12.512782	14.686474	10.413659	1.759746	111.010697
1618	Yerry Mina	Everton	Centre-Back	eng Premier League	7.318809	41.950024	22.517486	5.223504	9.673101	9.923798	11.875790	2.017445	110.499957
1648	Thuler	Montpellier	Centre-Back	fr Ligue 1	7.350381	32.037448	19.681073	5.200998	10.019660	9.447145	11.930146	1.404903	97.071754
1653	Lyanco	Southampton	Centre-Back	eng Premier League	7.546827	34.285118	16.030670	5.775505	10.776942	11.582455	10.999401	1.695802	98.692719
1673	Márton Dárdai	Hertha BSC	Centre-Back	de Bundesliga	6.999585	29.800904	16.884119	5.593371	11.297267	13.158769	12.275611	1.578228	97.587854
1769	Matt Miazga	Alavés	Centre-Back	es La Liga	7.273206	42.049392	25.763505	5.561516	8.534530	9.446319	11.716991	2.026379	112.371838

In [323]:

#Round overall ratings

newdf = newdf.round({'Minutes (12.5%)': 2})
newdf = newdf.round({'Defending (20%)': 2})
newdf = newdf.round({'Aerial (20%)': 2})
newdf = newdf.round({'Front Foot (5%)': 2})
newdf = newdf.round({'Ball Carrying (15%)': 2})
newdf = newdf.round({'Ball Playing (15%)': 2})
newdf = newdf.round({'Ball Retention (10%)': 2})
newdf = newdf.round({'Attacking Threat (2.5%)': 2})
newdf = newdf.round({'CB_Rating': 2})

newdf.sort_values("CB_Rating", ascending=False)

Out[323]:

	Player	Squad	Main Position	Comp	Minutes (12.5%)	Defending (20%)	Aerial (20%)	Front Foot (5%)	Ball Carrying (15%)	Ball Playing (15%)	Ball Retention (10%)	Attacking Threat (2.5%)	CB_Rating
710	Nathan Aké	Manchester City	Centre-Back	eng Premier League	7.59	40.39	26.99	4.64	20.16	15.02	11.87	2.32	128.98
648	Dan-Axel Zagadou	Dortmund	Centre-Back	de Bundesliga	7.69	46.01	26.38	4.69	15.79	15.25	11.44	1.59	128.85
159	Nico Schlotterbeck	Freiburg	Centre-Back	de Bundesliga	14.12	40.00	24.28	4.47	15.67	17.38	6.44	3.05	125.42
493	Adam Webster	Brighton	Centre-Back	eng Premier League	9.38	40.30	25.44	4.24	17.90	17.15	8.65	2.12	125.18
1209	Marc-Oliver Kempf	Stuttgart	Centre-Back	de Bundesliga	7.30	43.40	21.10	6.28	15.49	16.63	12.00	2.89	125.09
127	Konstantinos Mavropanos	Stuttgart	Centre-Back	de Bundesliga	13.84	39.94	26.45	4.39	14.06	15.36	6.51	2.58	123.13
619	Chris Richards	Hoffenheim	Centre-Back	de Bundesliga	8.93	44.61	22.60	5.69	13.85	14.74	9.33	2.38	122.12
1362	Leo Skiri Østigård	Genoa	Centre-Back	it Serie A	8.46	46.99	26.88	4.22	11.35	12.58	9.24	1.80	121.52
762	Clément Lenglet	Barcelona	Centre-Back	es La Liga	7.25	33.43	12.09	6.49	24.64	22.46	12.85	1.48	120.69
886	Ibrahima Konaté	Liverpool	Centre-Back	eng Premier League	7.82	40.10	22.89	4.14	14.80	16.98	11.24	1.63	119.60
95	Niklas Süle	Bayern Munich	Centre-Back	de Bundesliga	10.80	33.23	21.69	4.16	18.64	20.29	8.01	2.22	119.04
24	Dayot Upamecano	Bayern Munich	Centre-Back	de Bundesliga	12.11	34.26	17.80	5.23	19.73	20.56	7.33	1.81	118.82
1331	Giorgio Scalvini	Atalanta	Centre-Back	it Serie A	7.03	36.05	20.07	5.91	13.67	19.27	12.59	4.15	118.72
62	Lucas Hernández	Bayern Munich	Centre-Back	de Bundesliga	11.47	29.53	18.73	4.97	20.20	22.28	7.56	1.54	116.29
170	Mohammed Salisu	Southampton	Centre-Back	eng Premier League	14.78	37.81	21.72	4.46	13.78	15.23	6.13	2.09	115.99
399	Lucas Martínez Quarta	Fiorentina	Centre-Back	it Serie A	9.37	35.85	20.52	4.76	18.78	15.06	9.15	2.46	115.94
285	Andreas Christensen	Chelsea	Centre-Back	eng Premier League	9.60	39.10	19.59	4.10	15.49	17.19	8.91	1.53	115.51
260	Benoît Badiashile	Monaco	Centre-Back	fr Ligue 1	10.80	36.72	24.56	4.58	12.59	16.12	7.94	2.16	115.47
64	Joško Gvardiol	RB Leipzig	Centre-Back	de Bundesliga	12.80	32.19	18.19	4.68	18.38	19.86	6.84	2.46	115.40
937	Abdou Diallo	Paris S-G	Centre-Back	fr Ligue 1	7.43	27.33	21.60	5.82	20.01	19.12	12.06	1.67	115.04
385	Timo Hübers	Köln	Centre-Back	de Bundesliga	10.45	41.82	20.72	5.47	13.19	13.30	8.02	2.02	115.00
44	Nikola Milenković	Fiorentina	Centre-Back	it Serie A	14.62	36.79	24.57	3.68	13.26	13.14	6.49	2.07	114.61
94	Obite N'Dicka	Eint Frankfurt	Centre-Back	de Bundesliga	14.37	39.14	21.31	4.61	13.16	12.86	6.41	2.36	114.22
43	Robin Le Normand	Real Sociedad	Centre-Back	es La Liga	16.03	35.60	23.45	3.47	13.90	12.14	6.18	1.84	112.61
268	Gleison Bremer	Torino	Centre-Back	it Serie A	14.49	43.10	18.79	5.33	11.00	10.64	6.40	2.83	112.57
1769	Matt Miazga	Alavés	Centre-Back	es La Liga	7.27	42.05	25.76	5.56	8.53	9.45	11.72	2.03	112.37
1518	Ohis Felix Uduokhai	Augsburg	Centre-Back	de Bundesliga	7.11	37.56	22.26	6.00	11.92	13.89	12.20	1.42	112.37
236	Maxence Lacroix	Wolfsburg	Centre-Back	de Bundesliga	13.09	37.50	20.53	4.15	13.96	14.40	6.74	1.95	112.32
1266	Alessandro Buongiorno	Torino	Centre-Back	it Serie A	8.49	41.54	21.66	5.12	12.38	11.74	9.53	1.83	112.30
811	Merih Demiral	Atalanta	Centre-Back	it Serie A	11.08	41.49	24.34	5.45	9.87	9.37	7.68	2.74	112.02
68	Pau Torres	Villarreal	Centre-Back	es La Liga	14.37	29.39	18.30	3.24	19.18	18.00	6.49	2.46	111.42
125	Ronald Araújo	Barcelona	Centre-Back	es La Liga	12.32	33.49	22.00	4.04	16.25	13.85	7.22	2.13	111.31
1227	Nathan Collins	Burnley	Centre-Back	eng Premier League	10.21	41.65	22.05	3.90	10.46	12.55	7.59	2.65	111.06
1565	Guilherme Ramos	Arminia	Centre-Back	de Bundesliga	7.53	40.23	18.42	5.47	12.51	14.69	10.41	1.76	111.01
39	Jules Koundé	Sevilla	Centre-Back	es La Liga	13.95	32.63	19.42	3.59	16.98	15.56	6.66	2.08	110.87
889	Loïc Bade	Rennes	Centre-Back	fr Ligue 1	7.81	34.77	19.99	3.67	17.38	13.79	11.51	1.80	110.73
452	Davinson Sánchez	Tottenham	Centre-Back	eng Premier League	10.07	35.42	18.05	4.62	16.68	14.73	8.39	2.55	110.51
1618	Yerry Mina	Everton	Centre-Back	eng Premier League	7.32	41.95	22.52	5.22	9.67	9.92	11.88	2.02	110.50
73	Jonathan Tah	Leverkusen	Centre-Back	de Bundesliga	14.45	34.39	22.63	3.74	13.49	13.24	6.53	1.83	110.31
396	Koray Günter	Hellas Verona	Centre-Back	it Serie A	12.81	39.80	20.79	3.77	11.56	13.26	6.83	1.50	110.31
419	Piero Hincapié	Leverkusen	Centre-Back	de Bundesliga	10.50	35.00	17.35	5.47	17.72	14.44	7.86	1.81	110.15
58	Manuel Akanji	Dortmund	Centre-Back	de Bundesliga	12.28	31.44	17.96	4.69	17.07	17.07	7.25	2.10	109.87
107	Axel Disasi	Monaco	Centre-Back	fr Ligue 1	13.90	32.85	19.77	4.12	15.39	15.01	6.66	2.12	109.82
259	Mohamed Simakan	RB Leipzig	Centre-Back	de Bundesliga	11.40	32.97	22.38	4.56	14.76	14.12	7.49	1.97	109.66
35	Nayef Aguerd	Rennes	Centre-Back	fr Ligue 1	13.95	33.64	22.05	3.43	13.54	13.49	6.69	2.20	108.99
491	Boubakar Kouyaté	Metz	Centre-Back	fr Ligue 1	13.70	38.55	22.36	4.64	10.72	9.90	6.57	2.12	108.56
1401	Bosko Sutalo	Hellas Verona	Centre-Back	it Serie A	7.58	38.58	17.74	5.54	12.86	13.50	10.92	1.82	108.53
175	Alexander Djiku	Strasbourg	Centre-Back	fr Ligue 1	13.80	29.79	20.68	3.87	14.17	17.55	6.60	2.02	108.48
121	Matthijs de Ligt	Juventus	Centre-Back	it Serie A	13.73	35.71	21.61	4.06	13.11	11.35	6.73	2.15	108.44
20	Rúben Dias	Manchester City	Centre-Back	eng Premier League	12.78	27.32	16.29	3.95	21.70	16.85	7.16	2.31	108.36
61	Éder Militão	Real Madrid	Centre-Back	es La Liga	14.98	32.46	21.75	3.63	13.69	13.00	6.42	2.41	108.34
1557	Marc-Oliver Kempf	Hertha BSC	Centre-Back	de Bundesliga	8.04	38.95	21.01	4.58	10.52	13.24	9.84	2.13	108.31
573	Alessio Romagnoli	Milan	Centre-Back	it Serie A	9.29	35.74	20.37	4.48	12.26	14.87	9.05	2.11	108.16
311	Mario Hermoso	Atlético Madrid	Centre-Back	es La Liga	10.89	30.13	20.59	4.10	15.47	16.64	7.78	2.51	108.11
1009	Omar Alderete	Valencia	Centre-Back	es La Liga	12.78	35.62	22.00	4.23	11.68	13.46	6.42	1.88	108.06
0	William Saliba	Marseille	Centre-Back	fr Ligue 1	15.72	26.43	16.46	4.10	19.54	17.52	6.34	1.91	108.02
1126	David Zima	Torino	Centre-Back	it Serie A	8.96	40.24	20.99	4.76	11.71	10.18	9.29	1.88	108.01
1206	Saidou Sow	Saint-Étienne	Centre-Back	fr Ligue 1	7.82	34.61	19.49	6.48	13.26	13.46	10.84	1.70	107.66
273	Jan Bednarek	Southampton	Centre-Back	eng Premier League	13.57	39.03	21.17	3.57	10.01	11.18	6.58	2.24	107.36
96	Çağlar Söyüncü	Leicester City	Centre-Back	eng Premier League	13.11	36.58	20.52	4.02	12.89	11.58	6.79	1.77	107.25
964	Ardian Ismajli	Empoli	Centre-Back	it Serie A	8.81	33.73	21.37	4.23	13.51	14.30	9.49	1.57	107.02
89	Alessandro Bastoni	Inter	Centre-Back	it Serie A	12.46	29.77	18.13	4.66	16.14	16.96	7.13	1.68	106.93
87	Kevin Danso	Lens	Centre-Back	fr Ligue 1	14.14	32.63	21.17	4.14	14.86	11.22	6.57	1.81	106.54
1217	Marvin Friedrich	Union Berlin	Centre-Back	de Bundesliga	8.45	38.54	18.05	4.71	11.73	12.98	9.36	2.60	106.42
215	Max Kilman	Wolves	Centre-Back	eng Premier League	13.78	32.34	19.93	3.82	14.53	13.45	6.62	1.76	106.24
320	Cristian Romero	Tottenham	Centre-Back	eng Premier League	10.82	33.48	17.92	5.45	15.74	13.23	7.83	1.77	106.23
105	Waldemar Anton	Stuttgart	Centre-Back	de Bundesliga	13.45	32.81	17.46	4.43	14.99	14.14	6.71	2.17	106.16
1050	Kevin Bonifazi	Bologna	Centre-Back	it Serie A	8.60	32.50	19.98	5.00	13.92	14.61	9.60	1.95	106.15
166	Catena	Rayo Vallecano	Centre-Back	es La Liga	15.72	34.59	22.35	3.25	10.52	11.54	6.15	1.99	106.10
418	Juan Foyth	Villarreal	Centre-Back	es La Liga	11.10	28.69	19.51	4.97	16.51	15.85	7.55	1.70	105.88
638	Yeray Álvarez	Athletic Club	Centre-Back	es La Liga	10.88	36.05	18.74	4.35	13.18	13.35	7.70	1.61	105.85
1100	Christopher Wooh	Lens	Centre-Back	fr Ligue 1	8.03	32.99	18.36	6.12	15.41	11.74	10.76	2.25	105.68
108	Gianluca Mancini	Roma	Centre-Back	it Serie A	14.45	29.18	18.55	4.37	14.63	15.75	6.45	2.23	105.60
303	Trevoh Chalobah	Chelsea	Centre-Back	eng Premier League	9.43	31.09	16.19	4.89	16.72	16.35	8.99	1.95	105.60
197	Sven Botman	Lille	Centre-Back	fr Ligue 1	12.24	32.41	22.11	3.92	12.54	13.03	7.23	2.02	105.48
14	Presnel Kimpembe	Paris S-G	Centre-Back	fr Ligue 1	13.39	27.84	19.72	3.27	16.85	15.68	7.03	1.61	105.38
614	Niklas Stark	Hertha BSC	Centre-Back	de Bundesliga	11.48	35.99	21.42	4.43	11.28	11.67	7.37	1.75	105.37
379	Brendan Chardonnet	Brest	Centre-Back	fr Ligue 1	13.77	34.80	20.14	3.77	12.01	12.42	6.63	1.82	105.36
75	Roger Ibanez	Roma	Centre-Back	it Serie A	14.49	29.26	20.05	3.82	15.92	13.04	6.46	2.17	105.21
254	Lucas Perrin	Strasbourg	Centre-Back	fr Ligue 1	13.13	27.18	18.62	4.06	15.92	17.98	6.80	1.48	105.17
998	Armel Bella Kotchap	Bochum	Centre-Back	de Bundesliga	10.55	36.17	22.44	4.64	11.22	10.60	7.64	1.78	105.05
18	Jean-Clair Todibo	Nice	Centre-Back	fr Ligue 1	15.28	28.63	15.98	4.30	16.70	15.76	6.29	2.08	105.02
1325	Rob Holding	Arsenal	Centre-Back	eng Premier League	7.32	40.71	17.10	4.24	11.28	10.34	12.29	1.71	104.98
489	Timo Baumgartl	Union Berlin	Centre-Back	de Bundesliga	11.95	34.22	18.52	5.36	11.49	14.18	7.04	2.14	104.89
93	Nico Elvedi	M'Gladbach	Centre-Back	de Bundesliga	12.88	35.50	20.02	3.86	12.45	10.71	7.09	1.97	104.49
80	Duje Ćaleta-Car	Marseille	Centre-Back	fr Ligue 1	11.57	26.50	21.07	3.34	17.09	15.04	7.65	2.09	104.35
122	Hiroki Ito	Stuttgart	Centre-Back	de Bundesliga	12.59	31.26	16.39	4.20	14.19	17.13	6.93	1.63	104.31
124	Philipp Lienhart	Freiburg	Centre-Back	de Bundesliga	14.42	33.11	18.66	3.13	13.38	12.70	6.46	2.20	104.06
1073	Marash Kumbulla	Roma	Centre-Back	it Serie A	7.95	33.89	19.31	6.05	12.79	11.04	10.85	2.08	103.96
223	Edmond Tapsoba	Leverkusen	Centre-Back	de Bundesliga	10.71	31.77	17.57	4.51	16.23	13.29	7.97	1.69	103.75
752	Leonardo Balerdi	Marseille	Centre-Back	fr Ligue 1	7.68	31.33	17.48	4.95	16.05	12.89	11.78	1.38	103.53
244	Moussa Niakhate	Mainz 05	Centre-Back	de Bundesliga	13.36	29.78	18.81	4.58	12.33	16.15	6.50	2.01	103.52
502	Reece Oxford	Augsburg	Centre-Back	de Bundesliga	13.80	37.12	19.97	3.64	10.07	10.22	6.46	2.19	103.47
1405	Nikola Maraš	Rayo Vallecano	Centre-Back	es La Liga	8.01	37.83	18.65	5.07	10.38	11.30	10.54	1.58	103.36
1069	Marin Pongračić	Dortmund	Centre-Back	de Bundesliga	7.25	33.19	15.78	6.31	14.95	12.01	12.64	1.17	103.29
100	Eric García	Barcelona	Centre-Back	es La Liga	11.50	26.37	14.29	4.37	18.82	18.74	7.69	1.46	103.25
930	Kristoffer Ajer	Brentford	Centre-Back	eng Premier League	11.35	31.99	18.53	4.11	13.88	14.33	7.02	1.96	103.16
582	Atakan Karazor	Stuttgart	Centre-Back	de Bundesliga	11.01	33.04	17.81	5.47	11.54	15.03	7.59	1.63	103.13
53	Joachim Andersen	Crystal Palace	Centre-Back	eng Premier League	14.58	30.14	19.28	3.23	12.93	14.87	6.39	1.70	103.12
566	Takehiro Tomiyasu	Arsenal	Centre-Back	eng Premier League	10.24	31.76	15.87	4.37	14.97	15.89	7.90	1.99	103.00
1162	Petko Hristov	Spezia	Centre-Back	it Serie A	8.73	36.78	20.70	4.17	10.66	11.02	9.46	1.42	102.94
220	Joseph Aidoo	Celta Vigo	Centre-Back	es La Liga	13.60	30.94	17.50	4.16	14.05	14.44	6.60	1.44	102.74
504	Florian Grillitsch	Hoffenheim	Centre-Back	de Bundesliga	9.60	26.68	14.14	5.14	16.71	19.85	8.87	1.65	102.64
341	Tuta	Eint Frankfurt	Centre-Back	de Bundesliga	12.01	31.71	17.40	5.08	13.71	13.23	7.08	2.31	102.52
115	Castello Lukeba	Lyon	Centre-Back	fr Ligue 1	11.70	31.50	16.97	4.33	14.13	13.94	7.52	1.87	101.96
722	Anel Ahmedhodzic	Bordeaux	Centre-Back	fr Ligue 1	9.09	27.24	19.46	4.39	15.87	14.64	9.30	1.85	101.84
47	Warmed Omari	Rennes	Centre-Back	fr Ligue 1	14.16	28.13	20.50	3.52	14.05	13.30	6.71	1.46	101.82
460	Nicolò Casale	Hellas Verona	Centre-Back	it Serie A	13.42	32.14	17.15	4.73	13.04	13.02	6.59	1.70	101.78
256	Gerzino Nyamsi	Strasbourg	Centre-Back	fr Ligue 1	14.82	30.90	20.28	3.58	12.31	11.33	6.34	2.22	101.78
25	Facundo Medina	Lens	Centre-Back	fr Ligue 1	13.45	24.12	12.71	4.59	19.34	18.88	6.82	1.79	101.69
1116	Paweł Dawidowicz	Hellas Verona	Centre-Back	it Serie A	8.55	32.18	16.15	5.48	14.89	12.58	9.87	1.87	101.58
846	Maxim Leitsch	Bochum	Centre-Back	de Bundesliga	9.75	34.59	17.45	4.66	12.28	12.57	8.46	1.80	101.55
1458	Andrés Andrade Cedeño	Arminia	Centre-Back	de Bundesliga	8.02	33.71	15.44	5.62	13.70	13.63	9.29	1.99	101.41
1026	Giorgio Altare	Cagliari	Centre-Back	it Serie A	9.49	32.44	15.85	5.03	12.44	15.50	8.08	2.55	101.37
406	Lilian Brassier	Brest	Centre-Back	fr Ligue 1	12.29	28.68	18.23	4.21	13.95	14.96	7.03	1.93	101.29
60	Gabriel Dos Santos	Arsenal	Centre-Back	eng Premier League	15.10	27.64	17.75	3.54	15.90	12.51	6.37	2.36	101.17
30	Marc Guéhi	Crystal Palace	Centre-Back	eng Premier League	15.65	29.69	16.85	3.47	14.09	13.09	6.21	1.94	100.99
533	Amos Pieper	Arminia	Centre-Back	de Bundesliga	12.70	34.69	18.49	4.24	10.35	11.87	6.76	1.75	100.85
427	Mickael Nade	Saint-Étienne	Centre-Back	fr Ligue 1	13.34	31.01	18.99	4.61	12.47	12.10	6.63	1.58	100.74
102	Igor	Fiorentina	Centre-Back	it Serie A	12.22	31.97	14.69	4.37	14.74	13.83	7.33	1.54	100.69
1139	Michael Svoboda	Venezia	Centre-Back	it Serie A	8.69	33.86	15.06	4.84	13.48	13.03	9.66	2.06	100.69
1491	Ozan Kabak	Norwich City	Centre-Back	eng Premier League	7.59	35.49	17.51	5.42	11.29	10.63	11.08	1.57	100.56
375	Jean-Charles Castelletto	Nantes	Centre-Back	fr Ligue 1	13.16	30.64	20.22	3.72	11.05	13.10	6.82	1.87	100.56
1514	Zinho Vanheusden	Genoa	Centre-Back	it Serie A	7.82	35.84	16.34	4.75	12.14	10.85	10.59	1.77	100.09
415	Sebastiaan Bornauw	Wolfsburg	Centre-Back	de Bundesliga	11.39	35.53	19.81	4.30	9.68	9.49	7.45	2.09	99.75
689	Kaan Ayhan	Sassuolo	Centre-Back	it Serie A	9.10	29.65	14.21	4.01	14.87	16.90	9.42	1.50	99.67
106	Ben White	Arsenal	Centre-Back	eng Premier League	14.45	28.86	16.70	3.46	14.25	13.71	6.42	1.70	99.57
879	Óscar Mingueza	Barcelona	Centre-Back	es La Liga	7.49	24.52	14.49	5.94	15.87	17.58	11.79	1.66	99.33
1023	Mason Holgate	Everton	Centre-Back	eng Premier League	11.84	33.35	21.00	4.00	9.71	10.65	6.82	1.76	99.13
295	Thilo Kehrer	Paris S-G	Centre-Back	fr Ligue 1	9.66	28.76	17.94	4.68	14.57	12.31	9.00	2.09	99.00
663	Andrea Carboni	Cagliari	Centre-Back	it Serie A	12.12	29.19	16.04	4.38	13.82	14.79	6.88	1.63	98.86
1060	Pascal Stenzel	Stuttgart	Centre-Back	de Bundesliga	7.50	26.02	12.38	5.87	14.17	19.43	11.59	1.77	98.72
1653	Lyanco	Southampton	Centre-Back	eng Premier League	7.55	34.29	16.03	5.78	10.78	11.58	11.00	1.70	98.69
785	Maximilian Bauer	Greuther Fürth	Centre-Back	de Bundesliga	10.28	35.91	18.82	4.68	9.98	9.17	8.03	1.59	98.47
294	Luca Kilian	Köln	Centre-Back	de Bundesliga	12.35	32.05	16.34	4.50	11.82	12.49	7.03	1.68	98.27
365	Pascal Struijk	Leeds United	Centre-Back	eng Premier League	11.56	31.65	15.48	5.32	11.50	13.31	7.45	1.90	98.18
637	Sebastiano Luperto	Empoli	Centre-Back	it Serie A	11.22	33.77	14.32	3.86	12.72	13.01	7.53	1.71	98.15
827	Karim Rekik	Sevilla	Centre-Back	es La Liga	8.20	30.28	16.79	5.31	12.57	12.38	10.59	1.88	98.01
753	Jorge Cuenca	Getafe	Centre-Back	es La Liga	13.76	32.60	19.50	3.54	9.61	10.97	6.21	1.79	97.97
622	Johan Vásquez	Genoa	Centre-Back	it Serie A	12.35	31.73	16.07	5.21	11.72	12.19	6.66	1.97	97.89
306	Stefan Posch	Hoffenheim	Centre-Back	de Bundesliga	12.07	29.72	12.06	4.95	14.42	15.53	7.05	1.92	97.73
185	Jean-Kevin Duverne	Brest	Centre-Back	fr Ligue 1	14.90	22.64	13.78	4.56	15.67	18.13	6.10	1.92	97.70
1673	Márton Dárdai	Hertha BSC	Centre-Back	de Bundesliga	7.00	29.80	16.88	5.59	11.30	13.16	12.28	1.58	97.59
693	Stian Rode Gregersen	Bordeaux	Centre-Back	fr Ligue 1	11.20	30.79	17.02	4.91	12.41	11.37	7.54	1.88	97.11
1648	Thuler	Montpellier	Centre-Back	fr Ligue 1	7.35	32.04	19.68	5.20	10.02	9.45	11.93	1.40	97.07
31	Milan Škriniar	Inter	Centre-Back	it Serie A	15.40	26.89	15.93	3.58	13.99	12.57	6.40	2.21	96.97
325	Martin Valjent	Mallorca	Centre-Back	es La Liga	15.51	28.43	18.91	3.27	12.08	10.85	6.20	1.38	96.63
77	Luiz Felipe	Lazio	Centre-Back	it Serie A	13.09	30.02	15.23	3.80	13.10	13.03	6.97	1.39	96.63
1066	Domingos Duarte	Granada	Centre-Back	es La Liga	10.27	32.40	18.86	3.75	10.12	11.29	7.84	1.72	96.24
525	Paul Jaeckel	Union Berlin	Centre-Back	de Bundesliga	11.53	31.34	15.15	4.71	12.10	12.68	7.27	1.33	96.11
612	Kurt Zouma	West Ham	Centre-Back	eng Premier League	11.64	31.71	19.79	3.15	10.77	9.86	7.45	1.74	96.11
1107	Robin Koch	Leeds United	Centre-Back	eng Premier League	9.87	32.81	16.14	5.16	9.89	12.14	8.05	1.95	96.01
323	Rodrigo Becão	Udinese	Centre-Back	it Serie A	15.33	27.33	18.41	4.91	11.52	10.34	6.10	1.94	95.88
966	Ben Godfrey	Everton	Centre-Back	eng Premier League	11.47	30.08	16.42	4.44	12.01	12.22	7.08	2.15	95.86
1389	Mads Bech Sørensen	Brentford	Centre-Back	eng Premier League	7.28	30.34	15.13	5.18	12.76	11.88	11.64	1.55	95.75
996	Moritz Jenz	Lorient	Centre-Back	fr Ligue 1	9.20	30.38	16.68	4.75	12.70	10.81	9.05	2.08	95.63
156	Pietro Ceccaroni	Venezia	Centre-Back	it Serie A	15.30	27.72	16.56	3.66	12.38	11.86	6.18	1.98	95.63
544	Hugo Guillamón	Valencia	Centre-Back	es La Liga	12.63	27.13	14.78	4.42	11.91	16.12	6.86	1.46	95.32
1197	Matteo Lovato	Cagliari	Centre-Back	it Serie A	8.69	33.74	16.32	4.91	9.55	10.84	9.45	1.59	95.09
598	Martin Erlic	Spezia	Centre-Back	it Serie A	13.39	33.32	16.80	3.81	9.52	9.29	6.60	2.18	94.91
630	Harold Moukoudi	Saint-Étienne	Centre-Back	fr Ligue 1	10.18	28.30	17.13	5.10	12.42	11.53	8.44	1.78	94.87
787	Kevin Akpoguma	Hoffenheim	Centre-Back	de Bundesliga	9.71	24.48	12.65	4.66	14.73	17.50	8.14	2.52	94.38
1083	Erik Palmer-Brown	Troyes	Centre-Back	fr Ligue 1	10.43	30.72	18.38	4.73	10.19	10.43	7.92	1.50	94.31
719	Flavius Daniliuc	Nice	Centre-Back	fr Ligue 1	8.89	27.98	13.57	5.20	13.63	13.92	9.56	1.52	94.27
1084	Mouctar Diakhaby	Valencia	Centre-Back	es La Liga	11.18	30.50	16.09	4.45	11.02	11.93	7.32	1.72	94.21
119	Fikayo Tomori	Milan	Centre-Back	it Serie A	13.89	28.95	13.86	4.72	11.95	11.88	6.65	1.96	93.87
1110	Fernando Calero	Espanyol	Centre-Back	es La Liga	8.17	30.44	13.17	5.25	12.30	12.15	10.31	1.30	93.10
184	Daniel Amartey	Leicester City	Centre-Back	eng Premier League	11.80	28.23	14.49	3.54	13.69	12.02	7.49	1.27	92.53
240	Arthur Theate	Bologna	Centre-Back	it Serie A	12.85	25.95	11.17	3.90	15.01	14.74	6.83	2.03	92.49
1018	Mattia Viti	Empoli	Centre-Back	it Serie A	9.58	32.41	11.10	4.77	12.38	11.85	8.61	1.56	92.26
445	Odilon Kossonou	Leverkusen	Centre-Back	de Bundesliga	10.64	28.52	13.83	4.51	12.99	12.05	7.89	1.41	91.84
642	José María Giménez	Atlético Madrid	Centre-Back	es La Liga	11.51	28.25	18.21	3.54	10.07	10.54	7.57	2.08	91.77
1172	Franco Russo	Mallorca	Centre-Back	es La Liga	9.49	30.50	15.95	3.96	10.33	11.53	8.31	1.72	91.77
307	Nicolas Cozza	Montpellier	Centre-Back	fr Ligue 1	14.07	25.04	13.80	4.27	13.63	12.13	6.43	1.88	91.24
817	Jason Denayer	Lyon	Centre-Back	fr Ligue 1	7.87	31.13	11.54	4.22	11.33	10.71	11.53	2.47	90.77
783	Andrew Gravillon	Reims	Centre-Back	fr Ligue 1	11.84	25.13	15.59	3.66	12.01	13.59	6.98	1.75	90.56
1155	Erhan Mašović	Bochum	Centre-Back	de Bundesliga	9.80	32.25	14.53	4.46	9.68	9.87	8.11	1.50	90.19
604	Ezri Konsa	Aston Villa	Centre-Back	eng Premier League	13.04	28.76	16.20	3.53	10.16	9.47	6.84	2.11	90.10
226	Wout Faes	Reims	Centre-Back	fr Ligue 1	16.03	26.04	14.42	3.30	11.39	10.64	6.17	2.06	90.05
610	Rober	Levante	Centre-Back	es La Liga	11.40	26.88	11.20	4.44	13.27	13.28	7.38	1.88	89.73
627	Louis Beyer	M'Gladbach	Centre-Back	de Bundesliga	9.21	25.44	11.87	4.83	14.55	12.66	9.13	1.82	89.51
813	Maxime Estève	Montpellier	Centre-Back	fr Ligue 1	10.87	29.22	14.32	4.30	11.23	10.05	7.76	1.70	89.46
972	Nehuén Pérez	Udinese	Centre-Back	it Serie A	10.29	27.57	12.89	5.07	12.41	11.27	7.82	2.12	89.43
1231	Timothee Pembele	Bordeaux	Centre-Back	fr Ligue 1	9.31	21.65	12.20	4.71	16.84	13.22	8.17	3.11	89.21
182	Dimitris Nikolaou	Spezia	Centre-Back	it Serie A	15.72	25.45	11.77	3.83	12.99	11.88	6.11	1.28	89.02
1064	Jakub Kiwior	Spezia	Centre-Back	it Serie A	11.24	27.32	15.02	5.47	9.54	10.62	7.31	1.68	88.20
1354	Issa Diop	West Ham	Centre-Back	eng Premier League	7.73	29.06	12.57	4.82	11.43	10.04	11.08	1.44	88.17
1260	Raúl Torrente	Granada	Centre-Back	es La Liga	8.85	29.05	12.35	4.82	11.63	10.99	8.95	1.50	88.15
824	Luca Ranieri	Salernitana	Centre-Back	it Serie A	11.73	22.58	12.27	3.65	12.89	15.75	6.83	1.80	87.50
467	Dylan Bronn	Metz	Centre-Back	fr Ligue 1	13.28	24.44	12.50	4.07	11.78	11.33	6.70	1.87	85.98
196	Tiago Djaló	Lille	Centre-Back	fr Ligue 1	12.52	22.10	11.00	4.31	14.06	12.32	7.08	1.86	85.26
989	Diego González	Elche	Centre-Back	es La Liga	10.64	27.55	12.86	3.72	9.46	9.63	7.83	1.42	83.11
816	Víctor Chust	Cádiz	Centre-Back	es La Liga	10.77	25.24	9.24	4.26	12.35	10.51	7.89	1.82	82.06
673	Daniel Vivian	Athletic Club	Centre-Back	es La Liga	11.32	25.85	9.05	3.99	11.15	10.71	7.51	2.24	81.82

In [324]:

#Download as CSV
newdf.to_csv('StatsbombU26CBs.csv', index=False)

In [279]:

#Below code is for Data Visual

In [280]:

#Seperating dataframe from player key information

dfviz = newdf.filter(['Player','Minutes (12.5%)','Defending (20%)','Aerial (20%)','Front Foot (5%)','Ball Carrying (15%)','Ball Playing (15%)','Ball Retention (10%)','Attacking Threat (2.5%)'], axis=1)

In [281]:

#Params for data visual
params = list(dfviz.columns)
params = params[1:]
params

Out[281]:

['Minutes (12.5%)',
 'Defending (20%)',
 'Aerial (20%)',
 'Front Foot (5%)',
 'Ball Carrying (15%)',
 'Ball Playing (15%)',
 'Ball Retention (10%)',
 'Attacking Threat (2.5%)']

In [282]:

#Players to select for data visual

dfviz.Player.unique()

Out[282]:

array(['William Saliba', 'Presnel Kimpembe', 'Jean-Clair Todibo',
       'Rúben Dias', 'Dayot Upamecano', 'Facundo Medina', 'Marc Guéhi',
       'Milan Škriniar', 'Nayef Aguerd', 'Jules Koundé',
       'Robin Le Normand', 'Nikola Milenković', 'Warmed Omari',
       'Joachim Andersen', 'Manuel Akanji', 'Gabriel Dos Santos',
       'Éder Militão', 'Lucas Hernández', 'Joško Gvardiol', 'Pau Torres',
       'Jonathan Tah', 'Roger Ibanez', 'Luiz Felipe', 'Duje Ćaleta-Car',
       'Kevin Danso', 'Alessandro Bastoni', 'Nico Elvedi',
       "Obite N'Dicka", 'Niklas Süle', 'Çağlar Söyüncü', 'Eric García',
       'Igor', 'Waldemar Anton', 'Ben White', 'Axel Disasi',
       'Gianluca Mancini', 'Castello Lukeba', 'Fikayo Tomori',
       'Matthijs de Ligt', 'Hiroki Ito', 'Philipp Lienhart',
       'Ronald Araújo', 'Konstantinos Mavropanos', 'Pietro Ceccaroni',
       'Nico Schlotterbeck', 'Catena', 'Mohammed Salisu',
       'Alexander Djiku', 'Dimitris Nikolaou', 'Daniel Amartey',
       'Jean-Kevin Duverne', 'Tiago Djaló', 'Sven Botman', 'Max Kilman',
       'Joseph Aidoo', 'Edmond Tapsoba', 'Wout Faes', 'Maxence Lacroix',
       'Arthur Theate', 'Moussa Niakhate', 'Lucas Perrin',
       'Gerzino Nyamsi', 'Mohamed Simakan', 'Benoît Badiashile',
       'Gleison Bremer', 'Jan Bednarek', 'Andreas Christensen',
       'Luca Kilian', 'Thilo Kehrer', 'Trevoh Chalobah', 'Stefan Posch',
       'Nicolas Cozza', 'Mario Hermoso', 'Cristian Romero',
       'Rodrigo Becão', 'Martin Valjent', 'Tuta', 'Pascal Struijk',
       'Jean-Charles Castelletto', 'Brendan Chardonnet', 'Timo Hübers',
       'Koray Günter', 'Lucas Martínez Quarta', 'Lilian Brassier',
       'Sebastiaan Bornauw', 'Juan Foyth', 'Piero Hincapié',
       'Mickael Nade', 'Odilon Kossonou', 'Davinson Sánchez',
       'Nicolò Casale', 'Dylan Bronn', 'Timo Baumgartl',
       'Boubakar Kouyaté', 'Adam Webster', 'Reece Oxford',
       'Florian Grillitsch', 'Paul Jaeckel', 'Amos Pieper',
       'Hugo Guillamón', 'Takehiro Tomiyasu', 'Alessio Romagnoli',
       'Atakan Karazor', 'Martin Erlic', 'Ezri Konsa', 'Rober',
       'Kurt Zouma', 'Niklas Stark', 'Chris Richards', 'Johan Vásquez',
       'Louis Beyer', 'Harold Moukoudi', 'Sebastiano Luperto',
       'Yeray Álvarez', 'José María Giménez', 'Dan-Axel Zagadou',
       'Andrea Carboni', 'Daniel Vivian', 'Kaan Ayhan',
       'Stian Rode Gregersen', 'Nathan Aké', 'Flavius Daniliuc',
       'Anel Ahmedhodzic', 'Leonardo Balerdi', 'Jorge Cuenca',
       'Clément Lenglet', 'Andrew Gravillon', 'Maximilian Bauer',
       'Kevin Akpoguma', 'Merih Demiral', 'Maxime Estève', 'Víctor Chust',
       'Jason Denayer', 'Luca Ranieri', 'Karim Rekik', 'Maxim Leitsch',
       'Óscar Mingueza', 'Ibrahima Konaté', 'Loïc Bade',
       'Kristoffer Ajer', 'Abdou Diallo', 'Ardian Ismajli', 'Ben Godfrey',
       'Nehuén Pérez', 'Diego González', 'Moritz Jenz',
       'Armel Bella Kotchap', 'Omar Alderete', 'Mattia Viti',
       'Mason Holgate', 'Giorgio Altare', 'Kevin Bonifazi',
       'Pascal Stenzel', 'Jakub Kiwior', 'Domingos Duarte',
       'Marin Pongračić', 'Marash Kumbulla', 'Erik Palmer-Brown',
       'Mouctar Diakhaby', 'Christopher Wooh', 'Robin Koch',
       'Fernando Calero', 'Paweł Dawidowicz', 'David Zima',
       'Michael Svoboda', 'Erhan Mašović', 'Petko Hristov',
       'Franco Russo', 'Matteo Lovato', 'Saidou Sow', 'Marc-Oliver Kempf',
       'Marvin Friedrich', 'Nathan Collins', 'Timothee Pembele',
       'Raúl Torrente', 'Alessandro Buongiorno', 'Rob Holding',
       'Giorgio Scalvini', 'Issa Diop', 'Leo Skiri Østigård',
       'Mads Bech Sørensen', 'Bosko Sutalo', 'Nikola Maraš',
       'Andrés Andrade Cedeño', 'Ozan Kabak', 'Zinho Vanheusden',
       'Ohis Felix Uduokhai', 'Guilherme Ramos', 'Yerry Mina', 'Thuler',
       'Lyanco', 'Márton Dárdai', 'Matt Miazga'], dtype=object)

In [401]:

#New dataframe for player / edit name to change visual

values = dfviz.loc[dfviz['Player']=='Niklas Süle'].reset_index()
values = list(values.loc[0])
values = values[2:]

In [402]:

#Check in place to ensure number of parameters and metric values are correct

print(len(params),len(values))

8 8

In [403]:

#Values for the player selected above

values

Out[403]:

[9.75, 30.43, 20.46, 3.73, 17.96, 19.77, 7.28, 2.08]

In [404]:

#Getting the min and max values for the ranges for the data visual

min_range = []
max_range = []

for x in params:
    a = min(dfviz[params][x])
    
    b = max(dfviz[params][x])

    min_range.append((a))
    max_range.append((b))

In [405]:

#Check min values

min_range

Out[405]:

[5.57, 17.7, 6.55, 2.6, 6.84, 7.54, 5.18, 0.92]

In [406]:

#Check max values

max_range

Out[406]:

[15.51, 45.57, 26.29, 6.29, 24.55, 22.16, 12.6, 4.2]

In [407]:

#Creating pizza chart

baker = PyPizza(
    params=params,
    background_color="white", straight_line_color="#000000",
    min_range=min_range,        # min range values
    max_range=max_range,        # max range values
    last_circle_color="#000000", last_circle_lw=2.5, straight_line_lw=1,
    other_circle_lw=0, other_circle_color="#000000", inner_circle_size=16.5,
)


# plot pizza
fig, ax = baker.make_pizza(
    values,                          # list of values
    figsize=(10, 10),                # adjust figsize according to your need
    color_blank_space="same",        # use same color to fill blank space
    blank_alpha=0.4,                 # alpha for blank-space colors
    kwargs_slices=dict(
        facecolor="#E40A27",edgecolor="#000000", zorder=2, linewidth=1
    ),                               # values to be used when plotting slices
    kwargs_params=dict(
        color="#000000", fontsize=13,
    ),                               # values to be used when adding parameter
    kwargs_values=dict(
        color="#000000", fontsize=13,
        bbox=dict(
            edgecolor="#000000", facecolor="#E40A27",
            boxstyle="round,pad=0.2", lw=1
        )
    )                                # values to be used when adding parameter-values
)

# Add Title / Edit Player Name and Club
fig.text(
    0.515, 0.975, "Niklas Süle - Bayern Munich", size=18, fontweight='bold',
    ha="center", color="#000000"
)

# Add Subtitle
fig.text(
    0.515, 0.956,
    "Centre Back Rating Breakdown | Top Five European Leagues 2021-22",
    size=14,
    ha="center", color="#000000"
)

# add credits
CREDIT_1 = "Graphic: @HenshawAnalysis"
CREDIT_2 = "Data is via Statsbomb"
CREDIT_3 = "Template: Centre Back Rating Breakdown"
CREDIT_4 = "Notes: Value in brackets is the weighting for that attribute"

fig.text(
    0.935, 0.000, f"{CREDIT_1}\n{CREDIT_2}\n{CREDIT_3}\n{CREDIT_4}", size=9,
    color="#545454",
    ha="right"
)

fig.text (0.511, 0.509, "Overall\nRating", size=12, ha="center", fontweight='bold')
fig.text (0.511, 0.48, "119.04", size=16, ha="center", fontweight='bold')



# add image

im2 = imageio.imread('SB_LogoNew.png')
ax_image = add_image(
    im2, fig, left=0.1, bottom=-0.09, width=0.22, height=0.22
)   # these values might differ when you are plotting

plt.show()

In [ ]: